Data Correction with Data Quality Services - SQL Server Integration Services Design Patterns - page 167

10. (Optional) Export the corrected data to SQL Server, CSV, or Excel.
You will be able to skip this step in most scenarios, since your SSIS
package will be responsible for handling the corrected data.
11. Click the Finish button to close the project.
12. From the home screen, select your knowledge base, and choose the
Domain Management activity.
13. Select the domain you have defined new rules for.
14. Click the Domain Values tab.
15. Click the Import Values button, and select Import project values (as
shown in Figure 5-17 ).
Figure 5-17 . Importing domain values from an existing project
16. Repeat steps 13-15 for each domain you wish to update.
17. Click the Finish button to publish your knowledge base changes.
18. If you have modified any of the correction rules, you may want to re-
run your SSIS package to pick up the new values.
Conclusion
This chapter described the new DQS Cleansing transform and how you can use it to
take advantage of the advanced data cleansing functionality provided by Data Quality
Services in SQL Server 2014. The design patterns detailed in this chapter will help you
get the best possible performance while doing data cleansing with SSIS.