Domain Value Import Component
With the SSIS DQS Domain Value Import Component, domain values can be imported into an existing knowledge base. You can use SQL Server, Flat Files, Oracle or every other by SSIS supported data sources to import values into DQS.
Define a DQS Connection Manager, an existing Knowledge Base and a Domain as a Destination for the data. Then perform a mapping of the input columns to the DQS columns. Type and synonym values are optional.
The Knowledge Base can be published through the component direct after execution or only when there is no error. If you don't publish the Knowledge Base through the component itself, you can publish the KB later through the Publish DQS Knowledge Base Task.