In this SSIS Tutorial I will show you to use SSIS 2012 Merge transformation. For the purpose of this tutorial I will use SSIS 2012.
Other Versions of SQL Server:
- SSIS 2012
- This blog post has been written using SSIS 2012
- SSIS 2008 / R2
- The examples we used should work in SSIS 2008 and R2
- SSIS 2005
- We suspect that this will work in SSIS 2005 as well
What is Merge Transformation?
We can combines two sources together using Merge. This is very similar to SQL UNION ALL and should not be confused with MERGE JOIN Transformation which is a different type of transformation.
Merge Transformation requires input sources to be sorted and we can dot hat using Sort Transformation that we will use in this tutorial. Sort requires additional resources so if sorted input/output is not beneficial for you than consider using UNION ALL Transformation instead.
As we can see below I have two sources and one connection to AdventureWorksDW2012.
In my first source I have 10 rows with First name, LastName and Gender for Male. In second source the same but for Female.
In this tutorial I will show you how to merge the rows together so we get 20 rows, 10 with male 10 with female.
To get full access to this page
Become a member or Sign in
Membership is just $3.99/month