Staging Stored Procedure

Staging Stored Procedure (Master Data Services)

 

Updated: April 1, 2016

Applies To: SQL Server 2016

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.

The following table lists the parameters of these stored procedures.

ParameterDescription
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:

 0: Do not log transactions.

 1: Log transactions.

 

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.
User NameOptional parameter
User IDOptional parameter

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'  
      @UserName=N’domain\user’  
  
GO  
  

Validation Stored Procedure (Master Data Services)
View Errors that Occur During Staging (Master Data Services)

Community Additions

ADD
Show:
© 2016 Microsoft