Staging Stored Procedure (Master Data Services)
When initiating the staging process from SQL Server Management Studio, you use one of three stored procedures.
stg.udp_name_Leaf
stg.udp_name_Consolidated
stg.udp_name_Relationship
Where name is the name of the staging table that was specified when the entity was created.
Staging Process Stored Procedure Parameters
The following table lists the parameters of these stored procedures.
Parameter |
Description |
|---|---|
VersionName Required |
The name of the version. This may or may not be case-sensitive, depending on your SQL Server collation setting. |
LogFlag Required |
Determines whether transactions are logged during the staging process. Possible values are:
For more information about transactions, see Transactions (Master Data Services). |
BatchTag Required, except by web service |
The BatchTag value as specified in the staging table. |
Batch_ID Required by web service only |
The Batch_ID value as specified in the staging table. |
Staging Process Stored Procedure Example
The following example shows how to start the staging process by using the staging stored procedure.
USE [DATABASE_NAME]
GO
EXEC[stg].[udp_name_Leaf]
@VersionName = N'VERSION_1',
@LogFlag = 1,
@BatchTag = N'batch1'
GO
See Also
Tasks
Load or Update Members in Master Data Services by Using the Staging Process
View Errors that Occur During the Staging Process (Master Data Services)