Master Data Services

Bulk Loading into MDS using SSIS

Bulk Loading into MDS using SSIS

Each entity in SQL Server 2012 Master Data Services (MDS) will have it’s own staging table (stg.<name>_Leaf). Using this staging table, you can create, update, deactivate and delete left members in bulk. This post describes how to bulk load into an entity staging table and trigger the stored procedure to start the batch import process. … Continued

EIM presentation material from DevTeach Montreal

EIM presentation material from DevTeach Montreal

I presented an Enterprise Information Manager talk earlier this week at the DevTeach Montreal conference. Unlike my previous talk from TechEd North America, which tackled the problem from the Data Curation (DQS/MDS) side, this talk has a focus on using SSIS to integrate and automate your solution. The demo files are now available from my … Continued

SSIS & EIM Talks From TechEd North America 2012 Now Available

The recordings of my the SSIS sessions I presented at TechEd North America 2012 are now available online. Incremental ETL Using CDC for SQL and Oracle with SQL Server Integration Services (SSIS) 2012 Enterprise Information Management (EIM): Bringing Together SSIS, DQS, and MDS

SQL Server 2012 Case Studies for DQS

I’ve had a lot of people ask me recently for real-life examples of how customers are using Data Quality Services (DQS). Even though SQL Server 2012 has been out less than a month, we already have a number of case studies published which describe how DQS plays a key role within a customer’s infrastructure. Most … Continued

Getting Started with DQS and MDS

If you’re looking to get started with Data Quality Services (DQS) and Master Data Services (MDS), there are some fantastic resources available on Technet. The site includes videos and slides for full day training sessions on both products. Data Quality Services for SQL Server 2012 Data Quality Basics and Introducing DQS: Video | Slides Knowledge … Continued