[Tutorial] Automating Data Cleaning and Validation with DQS and SSIS, Part 2

In part 1 of this article, I outlined how a data steward – a person who is responsible for data quality and typically not on the IT staff – would create a collection of rules that can be used to automate data cleansing and address verification.  In this post, I will...

[Tutorial] Automating Data Cleaning and Validation with DQS and SSIS, Part 1

Automating Data Cleaning and Validation with DQS and SSIS, Part 1   I have been doing some work with SQL Server Data Quality Services (DQS) in preparation for SQL Saturday in Salt Lake City (https://www.sqlsaturday.com/349/eventhome.aspx ).  Part of my code...