Blog Post

SQL Server Integration Services (SSIS) Blog
1 MIN READ

Exporting Master Data White Paper Published

SSIS-Team's avatar
SSIS-Team
Copper Contributor
Mar 25, 2019
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


Updated Mar 25, 2019
Version 2.0
No CommentsBe the first to comment