Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Load or Update Members by Using the Staging Process

Load or Update Members in Master Data Services by Using the Staging Process


Applies To: SQL Server 2016 Preview

In Master Data Services, you can use the staging process to create, update, and delete members in bulk. You can also use the staging process to set and update attribute values.


To perform this procedure:

  • You must have permission to insert data into the stg.name_Leaf (for leaf members) or the stg.name_Consolidated (for consolidated members) table in the Master Data Services database.

  • You must have permissions to execute either the stg.udp_name_Leaf (for leaf members) or stg.udp_name_Consolidated (for consolidated members) stored procedure in the Master Data Services database.

  • The model must not have a status of Committed.

To load members into the MDS database

  1. Prepare the members for import into the appropriate staging table in the Master Data Services database.

  2. Open SQL Server Management Studio and connect to the Database Engine instance for your Master Data Services database.

  3. Import the data into the Master Data Services database. For information about importing data into a database by using SQL Server Integration Services, see Run the SQL Server Import and Export Wizard.

  4. After you successfully import the data, run the stored procedure to load the staged data into the appropriate tables in the MDS database. For more information on the stored procedure, see Staging Stored Procedure (Master Data Services).

Next Steps

Community Additions

© 2015 Microsoft