In the following example I’ve created an SSIS that audits the transfer of data each step of the way. The main transformations used for this were: Row Count The row count was used to validate the number of records Conditional Split Was used to split out rows with a specific Header value. In this case […]