This component provides capabilities to import domain values including synonyms into an existing knowledge base. The intention of the component is to help you automate you DQ Projects and provide more efficient ways
to maintain Knowledge Bases (KB).
Now with support for SQL Server 2012, SQL Server 2014 and SQL Server 2016 CTP 2.3.
A note beforehand: The DQS API is not officially supported by Microsoft.
The SSIS DQS Domain Value Import is developed and tested for SQL Server 2012 with DQS assembly version 11.0.3000.0. We try to support future versions of DQS and SQL Server. However, we cannot guarantee that the component will work with all future versions of
The component enables you to import large sets of valid/invalid/error values as well as synonyms for a specified Domain. The idea of the project is based on the existing functionality "Import
Values from an Excel File into a Domain".
In addition to the Data Flow component, the Publish DQS Knowledge Base Task belongs to the Project. The task allows you to publish a knowledge base, which is in status domain Management.
A very good description on how to use the component can be found in the following blog series on the Data Quality Services Blog: