Before I m going to start Merge Join Transformation. Please go through the Merge Transformation topic whatever I have explained in the previous article. Here I m going to take an example that I have explained in Merge Transformation.
Where we can see the Merge Join Transformation in SSIS?
By using Merge Join Transformation, we can combine the two sources to pull the data. generally, how we will create the SQL Query to pull the data in SSMS same way to do by using Merge Join Transformation
Have look at the below screenshot. we have two sources of data for student details. Here I m going to pull the data student available in both source by using Merge Join Transformation with Inner Join Operation
Add the Merge Join Transformation in your package. before creating two source data. Have look at the below Package design.
After you have placed the Merge Join Transformation. You join the two sources of data by using the SSIS precedence constraint. Once you have connected with Merge Join. You have defined the joining column and Type of Join. Reference image below.
Once you have done the proper setup, you can run the package and see the result