LEFT Function in SSIS Expressions

There are a number of small changes to Integration Services in SQL Server Denali that might not be immediately apparent. One of these is the new LEFT function in the http://msdn.microsoft.com/en-us/library/ms141671.aspx .

This new function provides a simpler way to get the first part of string expression - prior to Denali, you’d use the http://msdn.microsoft.com/en-us/library/ms137541.aspx with an offset of zero.

Helpful Denali links:

• http://blogs.msdn.com/b/mattm/archive/2010/11/22/sql-server-denali-resource-center.aspx
• http://msdn.microsoft.com/en-us/library/bb500435(SQL.110).aspx
• http://msdn.microsoft.com/en-us/library/bb522534(v=SQL.110).aspx