Preview Content - log in or Join KEBI Academy

SSIS Union All Transformation

Video

To access members only content log in
or join KEBI Academy and unlock your potential

Just $8/month
Silver Membership
View more
7 Days Free Trial
Subscriptions only
View more
Fast Learning
made easy & affordable
View more
207 fellow members joined KEBI Academy
+48 members in last 30 days

Article

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. 

To access members only content log in
or join KEBI Academy and unlock your potential

Just $8/month
Silver Membership
View more
7 Days Free Trial
Subscriptions only
View more
Fast Learning
made easy & affordable
View more
207 fellow members joined KEBI Academy
+48 members in last 30 days
Did you find this page useful?

+2  |  -0
(2 Votes)