0 out of 2 rated this helpful - Rate this topic

Staging Stored Procedure (Master Data Services)

SQL Server 2012

When initiating the staging process from SQL Server Management Studio, you use one of three stored procedures.

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.

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

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

Validation Stored Procedure (Master Data Services)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions