Video : How to Import Data Into Master Data Services

Leave a comment (1) Go to comments

This video shows how to import data from source systems into an existing SQL Server 2008 R2 Master Data Services model.

This video demonstrates the following:

  • How to write T-SQL Scripts to import source data into staging tables
  • How to process import batches in Master Data Manager
  • How to verify results of the import scripts

Step by Step Video Tutorial to Import Data Into Master Data Services

Presented by Ty Anderson

EOF - Video : How to Import Data Into Master Data Services, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000
Leave a comment


  1. At the end of the tutorial you have duplicates. Isn’t MDS supposed to help with data cleansing as well? “One version o fthe truth” and all that? Do you have a video on how to utilize MDS to clean up duplicates and fill in gaps .. like the versions of the “A Bike Shop”, one with an address and one without, or perhaps they could have different addresses and they need to be merged, or there’s a typo in one of the addresses, or even the name of the Bike Shop itself. This product is billed as an easier way to deal with these kinds of issues, but does it actually assist with that part of the work?

Leave a Reply

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


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.