Sort Transformation

The Sort transformation sorts input data in ascending or descending order and copies the sorted data to the transformation output. We can apply sort on multiple columns of the input data. 

Take data flow task

Double click on data flow task.

In Data flow I am taking Excel data flow source.

This is my excel sheet which I want to sort.

Make the excel connection. After that I have take data conversion transformation.

Now I am taking sort transformation.

Double click on the Sort Transformation. Select the fields and also select the fields of the fields which you want to sort. Here I am sorting according to Employee ID. Sorting mode is ascending.

Click ok.

Sorting may be 1. Ascending order or 2. Descending order.

Comparison Flags: -

Ø  Ignore case: - Determines whether uppercase and lowercase letters are considered to be the same value.

Ø  Ignore kana type: - Determines whether kana type from the Japanese characters are ignored.

Ø  Ignore character width: - Determines whether single-byte and double-byte representations of the same character as identical.

Ø  Ignore non spacing characters: - Determines whether spacing characters and diacritics are considered identical.  For instance, whether “å” is equal to “a”.

Ø  Ignore symbols: Determines whether white: - space characters, punctuation, currency symbols, and mathematical symbols are considered in the sort.

Ø  Sort punctuation as symbols: - Determines whether the comparison sorts all punctuation symbols, except the hyphen and apostrophe, before the alphanumeric characters. For instance, if this option is set, “.ABC” sorts before “ABC”.

Now we take Oledb destination

Also I have take data viewer between sort and Oledb destination.

Now build the solution and execute the package.

Now see the sorted data according to the Employee ID.

Package Executed successfully.