Author Archives: MikeDavisSQL

SSIS For Each Loop over files with Date in Name

A common request I have received over the years is to move or copy files from one directory to another based on the file name.  This can be accomplished in SSIS without using any script task. You can do this … Continue reading

Posted in SSIS, Syndication | Tagged | 22 Comments

Using Checksum in SSIS for Delta Loads

The checksum function in SQL is a great way to compare two rows to see if the data matches. The checksum command returns a number that represents the value of the data in the row. When you compare the checksum … Continue reading

Posted in SSIS, Syndication | Tagged | 7 Comments