One extra note, if you do log to a flat file and there are no errors, SSIS will still create an empty log file at the path you specified.

Project Overview This project utilizes SQL Server Integration Services (SSIS) in Visual Studio to automate and streamline ETL (Extract, Transform, Load) processes. The SSIS package is designed to ...

You use the Data Quality Services (DQS) Cleansing transformation in a SQL Server-Integrated Service (SSIS) Data Flow to cleanse your data in Microsoft SQL Server 2012.