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.
