This project has moved and is read-only. For the latest updates, please go here.

Sort Input Columns Alphabetically

Apr 23, 2014 at 9:50 AM

I want to sort the input columns for Multiple Hash Component alphabetically. Any custom property or method available ?
Apr 29, 2014 at 1:35 AM
The Input Tab supports sorting by clicking on the Available Columns heading.
Or are you attempting to do this whilst generating a package programattically?
May 29, 2014 at 9:36 AM
I want to do this whilst generating a package programatically.
May 29, 2014 at 2:19 PM

As you are creating the package programmatically, you have full control of the order that columns are added to the data flow, or to any components that you add to the data flow.

When setting up the Input Collection, just add the columns into the collection in the order you desire.
When setting up the output columns custom property "InputColumnLineageIDs" value field, you should place the input columns id's into this in the order that you wish them to be used in the output hash.

The component itself doesn't provide any programmatic way to resort the input or output components.

Jun 12, 2014 at 4:06 AM

I have added a sample package to create an SQL 2012 Multiple Hash package onto the WIKI.

It improves on the previous SQL 2008 sample that is shown on this WIKI page, with better usage of the available classes in Multiple Hash.

Marked as answer by kmartin on 7/8/2014 at 6:14 AM