In this SSIS Tutorial I will show you how to use Sort Transformation in this article I will focus on Pass Through column. 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
This is Lesson 2 that covers Pass Through Column in SSIS Sort Transformation.
The Pass Through Column in Sort Transformation allow us to make selected column available after the Sort Transformation without having to sort it and in this video we give several examples.
I have got OLE DB Source with connection to AdventureWorks2012.
I have got some SQL with limited data.
I will use Sort Transformation and in this article I will focus on Pass Through column which means that the column witch we select in Pass Through will be enviable after Pass Through Transformation.
To get full access to this page
Become a member or Sign in
Membership is just $3.99/month