locked
MDS 2012 - Only Import data to final entity after manually executing in Integration Management UI RRS feed

  • General discussion

  • How can I load data through staging tables, and only import to final entity, by manually executing on the Integration Management screen.

    I am using the sp stg.udp_name_Leaf, but with this sp the data goes directly to the final entity with status = Completed

    Thanks

    Thursday, April 5, 2012 4:51 PM

All replies

  • When putting data into the staging tables, use the batch tag to differentiate between different sets of data. Every batch of data (identified by the unique batch tag) should show up as a separate row on the integration screen. More info here:

    http://msdn.microsoft.com/en-us/library/ee633726.aspx


    Arunjeet Singh (Microsoft SQL Server Master Data Services)

    Monday, April 30, 2012 7:53 AM