SSIS Union All Transformation

Are you a paid member?
Yes? Log in or Become a member

Unlimited use access passes from $9
and long term discounts up to 87%





In this SSIS Tutorial I will show you how to use Union All Transformation. For the purpose of this tutorial I will use SSIS 2012

Other Versions of SSIS:
  • SSIS 2012
    • This video has been created using SSIS 2012
  • SSIS 2008
    • The examples we used should work in SSIS 2008
  • SSIS 2005
    • We suspect that this will work in SSIS 2005 as well

Contents

 

Union All Transformation

The Union All Transformation allows us to combine multiple source inputs into one output.

I have got SSIS Package with two OLE DB Sources and connection to AdventureWorks2012. 

 

In first source I have got FirstName,Gender (which shows M for Male) and EmployeeKey.

And in second source I have got the same fields but gender shows F for Female value.

My task is to combine them together so 5 Males and 4 Females so I should get 9 rows. 

Are you a paid member?

Log in or Buy Membership
Unlimited use access passes from $9
and long term discounts up to 87%





Did you find this page useful? +2  |  -0
(2 Votes)