This blog provides information, news, tips, and announcements about the SQL Server Data Quality Services (DQS) feature introduced in SQL Server 2012.
There are times when you may want to update a DQS Knowledge Base through an automated process. For example, you add new products in your ERP system and you would like to make sure the new product names are added to DQS Knowledge Base automatically. A free codeplex project, SSIS DQS Domain Value Import, from OH22 data enables you to automate adding values into a DQS Knowledge Base. In this first of 3 part blog series, I walkthrough an example of using this component for adding new values to DQS Knowledge Base from a flat file. Part 2 of this series describes a more complex scenario of importing values of different types (correct/invalid) as well as setting up synonyms. The last article describe the error handling. Let's start with the first scenario.
As an example, suppose that we have a DQS Knowledge Base called Colors with an empty domain called Name:
The goal is to import the values from a flat file into the Colors Name:
The final SSIS project looks as follows:
Execute the SSIS project (make sure the DQS Knowledge Base is published before you execute the project, otherwise, you will get a run time error). Open the Knowledge Base from DQS Client and click on Domain Values tab to review the result:
All the values from the flat file are successfully imported into the DQS Knowledge Base.
In part 2 of this series, I describe the different options supported by SSIS DQS Domain Value Import, including how to import domain values with invalid types and set synonyms. In part 3 of this series, I will explain options to handle error and how you can view the error information.