Tag Archives: merge

SSIS Merge with Duplicate Rows

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

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