Daily Archives: September 29, 2011

Getting Previous Row in SSIS Data Flow

Posted on September 29, 2011 by MikeDavisSQL

There is no native function built in to SSIS to get the previous row in the data flow. But with a little work you can do this and make it perform much better than a SQL cursor and you don’t … Continue reading →

Posted in SSIS, Syndication | 1 Comment

SSIS Merge with Duplicate Rows

Posted on September 29, 2011 by MikeDavisSQL

The Merge component in SSIS will take two sorted sources and union them while maintaining the original sort order. The question arises, what about duplicate records. These duplicates do not get eliminated. Here are two tables with the ID 5 … Continue reading →

Posted in SSIS, Syndication | Tagged , | Leave a comment