October 21, 2014

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

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

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 demo involves validating addresses using MelissaData Address Check.  Address data… Read More