Summary

In this lab, you created a Data Quaity Services knowledge base to cleanse US state codes and email addresses. You then created a Data Quality Project to cleanse data in an Excel workbook. Finally, you updated an Integration Services package to use the DQS Cleansing component to cleanse the data as part of an ETL process.