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
Prepare the members for import into the appropriate staging table in the Master Data Services database.
For leaf members, use stg.name_Leaf. For more information about the required fields, see Leaf Member Staging Table (Master Data Services).
For consolidated members, use stg.name_Consolidated. For more information about the required fields, see Consolidated Member Staging Table (Master Data Services)
Open SQL Server Management Studio and connect to the Database Engine instance for your Master Data Services database.
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.
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).
View errors that occurred during staging. For more information, see View Errors that Occur During the Staging Process (Master Data Services).