Exporting Master Data White Paper Published

This post has been republished via RSS; it originally appeared at: SQL Server Integration Services (SSIS) articles.

First published on MSDN on Jul 17, 2012

Microsoft SQL Server 2012 Master Data Services (MDS) enables you to build and manage master data for your operational or analytical needs. But how do you export that master data from MDS into your systems? The "Exporting Master Data from Master Data Services" white paper at http://msdn.microsoft.com/en-us/library/jj218341.aspx shows you how. It describes the subscription views that you can export your master data into, and shows how to use SQL Server Integration Services (SSIS) to import your master data from a subscription view into a SQL Server table. Included is a step-by-step procedure that demonstrates how to set the process up, with sample T-SQL.

--Jim van de Erve, Content and Community Experience Group, Microsoft

Leave a Reply

Your email address will not be published. Required fields are marked *


This site uses Akismet to reduce spam. Learn how your comment data is processed.