As in my previous blog posts, I've been posting some new features in SQL Server 2012. In today's post, I would like to show you new features in SSIS. One of them is the left function wich till now you had to use substring to achieve the same result.
These are the new functions in SSIS:
- You now can easily return the leftmost portion of a string rather than use the SUBSTRING function. Left syntax is the same as we know in T-SQL:LEFT(character_expression,number)
- You can use this function to replace NULL values in the first argument with the expression specified in the second argument. This is equivalent to ISNULL in T-SQL:REPLACENULL(expression, expression)
- This function allows you to return a substring by using delimiters to separate a string into tokens and then specifying which occurrence to return:TOKEN(character_expression, delimiter_string, occurrence)
- This function uses delimiters to separate a string into tokens and then returns the count of tokens found within the string:TOKENCOUNT(character_expression, delimiter_string)