Floating FB popout byF5debug

SQL Server Integration Services (SSIS) – Part 51 – Merge Transformation (Setting Sorting) in SSIS


This is part 51 of the series of article on SSIS


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.


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 - http://f5debug.net/tutorial/ssis.aspx


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.


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

About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Add comment

  Country flag

  • Comment
  • Preview

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters


This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter