• SSIS Denali includes a new Left function. See this BOL topic for more information.

    http://msdn.microsoft.com/en-us/library/hh231081(SQL.110).aspx