SSIS Union All Transformation

In this SSIS lesson we will show you how to use Union All transformation that allows us to combine together multiple source of data into one.

Top Up

Instant Email Activation!

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



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. 

Activate this lesson >>

Let's Get In Touch!

Ready to start? That's great!
Give us a call or send us an email and we will help you get started!

  +1 800-501-1664

2015 © Katie & Emil LTD | Disclaimer | Privacy Policy | Disclosure Policy | Terms of use | Contact

Address: Kemp House, 152-160 City Road, EC1V 2NX, London