SSIS 2012 has introduced four new functions that can be used to manipulate data in components such as the Derived Column Transformation
componet. The new functions are:
Left
: As its name implies, this takes the left-hand side of a string from a data source. It is useful for operations such as trimming strings, where the target column is not as wide as the source and truncation is deemed to be acceptable; one example would be when apping Male/Female to M/F.ReplaceNull
: This is a very powerful feature that allows you to specify on a column by column basis, how nulls will be transformed from a data source. This is particularly useful in data cleansing operations to make null values from source systems consistent and ca be used instead ofIsNull
.TokenCount
: This is used to return the number of substrings within a stringbased on a particular token.Token
: This works with string data types to split up a string based on a particular token. This can be quite useful for parsing...