Project Description
This project contains the code for an SSIS custom transformation. This synchronous component transforms a column that contains a delimited string, sorts the delimited values, and removes any duplicate values from the delimited string. Two custom properties can be set at design time: StringDelimiter, which is the value of the delimiter, and CleanInputString, which is an option to clean the data by removing non-printable characters.

For example, if you have the following input:
RowNum DelimitedStrColName
1 Kirk,Donald,Anjan,Ritu,Catherine,Anjan
2 Jamie,Allan,Simon,Erik,Andy

You would see the following output:
RowNum DelimitedStrColName
1 Anjan,Catherine,Donald,Kirk,Ritu
2 Andy,Allan,Erik,Jamie,Simon

Last edited May 24, 2008 at 9:43 PM by JessicaMoss, version 2