Jack Corbett (3/19/2009)
It can be done in SSIS, but you have to use a Script Component to do it. Within the Script Component you would use the Split function which creates an array then you can add the columns to the Script Components output by looping through the array.
Hi Jack - would please be able to provide an example on how to do this using the Scrip Component?
I'm trying to accomplish the same thing, but I so far I have never needed to use that Component before.
Thanks
/Matthew