SSIS Tutorials - Merge Transformation || Merge data from two sources

In this tutorial, we will learn " How to merge data from two homogeneous or heterogeneous source" by using Merge Transformation in your SSIS Package. 

SSIS merge works similar way to a SQL join it merges the two or more different sources (Sources can be of same type or different type / heterogeneous) into a single output. SSIS is all about collecting data from different sources, If you want to merge the collected data from different sources then we can use merge component. Merge component accepts only 2 sorted (compulsory) inputs. if there is more than 2 inputs then it best to use Union All transformation component. Also Merge transformation have only 1 output and does not have any Error output.

Used Components -

1. Data Flow Task

2. Source Assistants - Flat File and SQL Server

3. Sort Transformation : To Sort the data

4. Merge Transformation : Merge the sorted inputs

5. Row Sampling: To watch the final output.