October 3, 2011 at 9:28 am
In `derived column transformation` how do i format string..
i have value of `abc = CCO Holdings, LLC`
now in `derived column` i want to write expression that gives me value of column `abc=CCO`
in another case name is
`AK STL` i want only `AK`
`so i want value till 1st space.`
October 3, 2011 at 9:32 am
You need to use left (col, patindex(find the space))
Replace won't work here.
P.S. What I have is for "normal" t-sql, never tried it with SSIS
October 3, 2011 at 1:57 pm
It isn't clear to me if you want the solution for SSIS or T-SQL.
The pattern provided by Ninja would apply to both.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply