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