This sample implements a simple EIM scenario by using SSIS, DQS, and MDS technologies together. The SSIS package in this sample cleanses the input data it reads from an Excel file against the Suppliers DQS knowledge base and then identifies and removes any duplicates in the data. SSIS includes the DQS Cleansing Transform component to invoke the cleansing functionality exposed by DQS. Currently, DQS does not expose matching functionality for SSIS to use, but you can use the Fuzzy Grouping Transform to identify duplicates in the data.

Download it from CodePlex at: http://msftdbprodsamples.codeplex.com/releases/view/100029.