In this step by step SSIS Tutorial I will show you how to use SSIS Conditional Split Transformation. For the purpose of this tutorial I will use SSIS 2012. There are a few main changes comparing to previous version of SSIS But the principle staying the same.
VIDEO: This is text based tutorial for video tutorial see Video SSIS Sort Transformation
Other Versions of SQL Server:
- SQL Server 2012
- This blog post has been written using SQL Server 2012
- SQL Server 2008 / R2
- The examples we used should work in SQL Server 2008 and R2
- SQL Server 2005
- We suspect that this will work in SQL Server 2005 as well
In this tutorial I present Sort Transformation using SSIS 2012. I will show you how to sort based on one column and two columns.
In my first example I will show you how to sort based on One column.
WHERE [ProductKey] BETWEEN 310 AND 313
AND [OrderDateKey] BETWEEN 20050701 AND 20050705
In a Data flow I have got OLE DB Source and Conection to AdventureWorksDW2012. I duble click the OLE DB Source.
In a source I have got some SQL. I click Preview.
I can see the data I have got in a ProductKey and OrderDataKey.
To get full access to this page
Become a member or Sign in
Membership is just $3.99/month