LEFT equivalent in SSIS Derived Column Task

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Stewart Campbell » LEFT equivalent in SSIS Derived Column Task

LEFT equivalent in SSIS Derived Column Task

Rate Topic

Display Mode

Topic Options

Author

Message

Stewart "Arturius" Campbell

Posted Monday, November 28, 2011 11:55 PM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 8:31 AM
Points: 3,129, Visits: 4,312

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

toine.rozemeijer 56683

Posted Tuesday, November 29, 2011 2:03 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, May 10, 2013 7:31 AM
Points: 4, Visits: 27

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

sabotta

Posted Tuesday, November 29, 2011 12:14 PM

SSC 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 »

Permissions