Tag Archives: merge

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

Using the SSIS Merge Join

Posted on September 6, 2011 by MikeDavisSQL

The Merge Join Transform in SSIS is a great way to load a Data warehouse quickly and an easy way to join two data sources together. There are a few requirements to join these two data sources. The data sources … Continue reading →

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