This is part 51 of the series of article on SSIS
Introduction:
In this article we are going to see on how to set the sorting properties of the merge transformation. In my previous article you can see the steps on how to use the merge transformation. To set the transformation merge we need to follow some setting which should be taken in the Source data source.
[more]Let’s jump start to see this sample on how to set the properties of the sorting. You can look into my series of article on SSIS at the url – https://f5debug.net/tutorial/ssis.php
Steps:
Follow steps 1 to 3 on my first article to open the BIDS project and select the right project to work on integration services project. Once the project is created, we will see on how to use the Merge Transformation task. Once you open the project just drag and drop the Merge transformation control and a source provider as shown in the previous article. Follow the steps till adding the merge control with the input data sources. Your screen will look like below
You can see some executing symbol shows on the data source as shown in the above screen and in the merge transformation you can see its showing the failed execution process.
Now right click on the data source (Merger Source 1) and select ”Show Advanced Editor” as shown in the below screen
Now move to the Input and output properties as shown in the below screen and select the IsSorted = true as shown below
Now click on the + symbol and go to Output columns and select SortkeyPosition to 1 as shown in the below screen
Now click on ok and go to the main screen, you can see Data Source 1 is configured correctly and the second one still showing the execution failure fail as shown below
Do the steps configuration which we did for Data source 2 as well and you can see the result set as shown below
Now you are done with the steps and the sorting properties as enable and ready for execution.
Conclusion:
So in this article we have seen on how to use the Merge transformation(Sorting properties) task and the key configurations used in order to use this task