Monthly Archives: August 2011

Convert EBCDIC to ASCII in SSIS

Posted on August 31, 2011 by MikeDavisSQL

    Converting EBCDIC to ASCII in SSIS 2008 can seem like a daunting task. There is a lot of manual work involved in creating a data flow to move data from an EBCDIC system like AS400 or DB2, to an … Continue reading →

Posted in SSIS, Syndication | Tagged , , | 10 Comments

SSIS For Each Loop over files with Date in Name

Posted on August 29, 2011 by MikeDavisSQL

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

Posted on August 15, 2011 by MikeDavisSQL

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