Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

LEFT equivalent in SSIS Derived Column Task Expand / Collapse
Author
Message
Posted Monday, November 28, 2011 11:55 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 6:19 AM
Points: 3,917, Visits: 5,109
Comments posted to this topic are about the item LEFT equivalent in SSIS Derived Column Task

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1212942
Posted Tuesday, November 29, 2011 2:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, February 7, 2014 6:44 AM
Points: 21, Visits: 31
Ummm. Why don't you just run a substring starting from the first position? That looks a lot easier then this.

SUBSTRING(<string here>,1,<length here>)
Post #1213009
Posted Tuesday, November 29, 2011 12:14 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, January 31, 2013 1:50 PM
Points: 27, Visits: 123
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
Post #1213483
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse