LEFT Function in SSIS Expressions

[SSIS-Team]

First published on MSDN on Jan 06, 2011

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 SSIS Expression language .

This new function provides a simpler way to get the first part of string expression - prior to Denali, you’d use the SUBSTRING with an offset of zero.

Helpful Denali links:

• Denali Resource Center
• What’s New (SQL Server “Denali”)
• What’s New (Integration Services)