Integration services

Hi all.
I'm playing about with SQL Integration Services and am in need of some help.
I'm trying to perform a transformation from one of our old systems. At the
time it was decided to store some data into a varchar(6000) column. Yep, a
long string of text. The text actually represents a data structure in
itself.
What I'm trying to do is take this one field and turn the data into several
rows on a data set. For example...
I'd like to turn this
Item1~Data1,Item2~Data2,Item3~Data3
Into this
Item1~Data1
Item2~Date2
Item3~Data3
Does anyone have any suggestions
Colin.See if this helps:
http://groups.google.com/group/micr...br />
db9a9b3d
Anith|||I gave up and decided to use the fn_spit function (from the MS Website)
similar the info in your link. I combined that with a cross apply to split
the data in sql before SSIS gets it's hands on it.
Regards
Colin.
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:uRdg91MVGHA.1304@.tk2msftngp13.phx.gbl...
> See if this helps:
> http://groups.google.com/group/micr... />
11db9a9b3d
> --
> Anith
>