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:
You would see the following output: