split the numbers
Or you can do it with a Regular Expression in a Script Component. Here is an Example of that (just come up with the right regex) Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com
September 9th, 2011 10:25am

But those are integers not strings,for strings may be split fn we used,can u explain abt that plz. to which post are you referring? I'm not getting it :-) But, you can use a Cast to convert between strings and numbers...Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
September 10th, 2011 9:41am

But those are integers not strings,for strings may be split fn we used,can u explain abt that plz.
September 10th, 2011 5:45pm

i have the phone number like this "123456789",i want split this number into 3 pieces like this 123 456 789,i have to load destination phone num column like "123 456 789",how can i achieve this one,plz help me.
Free Windows Admin Tool Kit Click here and download it now
September 11th, 2011 2:53am

create a Derived Column add a new Column, in the Expression add substring(yourfield,1,3) + " " + substring(yourfield,4,3) + " " + substring(yourfield,7,3) direct this new column to your destination
September 11th, 2011 3:24am

Something like this in the Derived Column: substring([phonenumber], 1 , 3) + " " + substring([phonenumber], 4 , 3) + " " + substring([phonenumber], 7 , 3)Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
September 11th, 2011 3:24am

Or you can do it with a Regular Expression in a Script Component. Here is an Example of that (just come up with the right regex)Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com
September 11th, 2011 3:29am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics