DQS and SSIS

Matching related and duplicate Customer Records can be done with SQL Server Data Quality Services (DQS). Here are two interesting blog posts by Welly Lee showing how to do it and how you can automate it with SSIS.

Many thanks to Oliver Engels and Tillmann Eitelberg for sharing their work with the community.

Matching related and duplicate Customer Records using SQL Server Data Quality Services (DQS)

SQL Server Data Quality Services (DQS) enables you to match records using your matching rules defined in DQS Knowledge Base. There are two common use cases where you would like to match related records. One is to identify duplicate in your records, such as same customers appear as separate records in your dataset. Another common case is to identify related customers. For example, you would like to identify two separate customer records that belong to the same parent company.
Read more...

Automating the data matching process in SQL Server Data Quality Services (DQS)

OH22 data has just released a free SSIS transform task for SQL Server Data Quality Services (DQS) matching. The solution is published on codeplex. With this custom transform task, you can use the Knowledge Base (KB) created in DQS to automate data matching through SSIS.
Read more...