Choosing Required Data in SSIS similar to filed function in datastage
Hi
My requirement is to choose data in a field after - for example
I have field (Name) containing Values
Name
dalla-s
new-yor-k
mar-yland
apple-i5-is-cool
Now from the above I need to choose the values after -
i.e as below
in datasatge it achieved using filed function
i.e when you say filed(Name,"-",2) you get the below values
Name
s
yor
yland
i5
How can i achieve this is SSIS ?
Thanks
September 12th, 2012 8:54pm
You need to place the Derived Column Transformation and derive a new field off a SSIS expression like:
SUBSTRING(@[User::StringVar], FINDSTRING(@[User::StringVar],"-",1)+1,FINDSTRING(@[User::StringVar],"-",2)-FINDSTRING(@[User::StringVar],"-",1)-1)
Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
September 12th, 2012 9:13pm
Look like what I am looking for I will update Thanks a LOT
September 13th, 2012 7:04pm
Hi it works amazing
Can you please explain the above expression.
Free Windows Admin Tool Kit Click here and download it now
September 17th, 2012 4:11pm
Hi Nag,
FINDSSTRING is just a very clever function, it finds the needed occurrences of a string.
E.g. I get the location of the 1st dash (- sign) with it, then the 2nd if exists and substring the text in between.Arthur My Blog
September 17th, 2012 4:54pm