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: LEFT - 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) REPLACENULL - You can use th...

Read More