Hi, is it possible to split data (Space Separated Values format) in a column
into several rows?

I have a datasource/data extraction where a column has multiple values
separated by space. Those values should be in a row record by themselves. I
was planning to connect the data to Script Component Transformation (SCT),
but the SCT doesn't allow adding of new rows. The Script Component Source
(SCS) has the ability to add new rows but it doesn't allow a source to be
connected.

Has anyone encountered these issues?

Thanks,
Benjamin

Hello Benjamin,


The Script Component as a Transform will allow you to put the same row into
the pipeline more than once.

Have a look at this

http://www.sqlis.com/default.aspx?307

Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com