Data Cleanser is an SSIS Data Flow Component that can be used to perform a handful of data cleansing tasks on strings. You can use Data Cleanser to normalize / tidy data from particularly unconstrained input sources.