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

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

Look like what I am looking for I will update Thanks a LOT

Hi it works amazing Can you please explain the above expression.

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