O'Reilly logo

Microsoft SQL Server 2008 R2 Master Data Services by Jeremy Kashel, Tim Kent, Martyn Bullerwell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Automating the MDS load process with SSIS

Master Data Services does not include the functionality to import data itself. This can be carried out using another component of SQL Server: SQL Server Integration Services (SSIS). SSIS is an enterprise-level extract, transform, and load (ETL) tool that compliments MDS well. There are many books and a huge amount of information already available about SSIS, so we won't be covering any "how-to" information on the product itself. Instead, we will look at the process of building a package to load data into MDS and invoke the staging and validation processes. The exercise assumes you are competent in building basic SSIS packages.

The package will essentially follow the process we have already discussed in ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required