Transforming Into Multiple Rows

#1

Hi,

I'm building a DTS package and one of the tasks it needs to do is to
transform an existing order table in this format:
UserID OrderID
1 0010, 003c, 0145
2 045, x15
3 x9010

to a table of this format:
UserID OrderID
1 0010
1 003c
1 0145
2 045
2 x15
3 x9010

How can I use DTS to transform a single role from the source into multiple
rows in destination? Should I use ActiveX Scripting?

Thanks,
ywb

#2

Hello WB,

You can use this

Processing The Same Row More Than Once
(http://www.sqldts.com/default.aspx?266)

Allan

Quote:

Hi,

I'm building a DTS package and one of the tasks it needs to do is to
transform an existing order table in this format:
UserID OrderID
1 0010, 003c, 0145
2 045, x15
3 x9010
to a table of this format:
UserID OrderID
1 0010
1 003c
1 0145
2 045
2 x15
3 x9010
How can I use DTS to transform a single role from the source into
multiple rows in destination? Should I use ActiveX Scripting?

Thanks,
ywb

#3

Yes! That worked!

Thanks Allan.

"Allan Mitchell" wrote:

Quote:

Hello WB,

You can use this

Processing The Same Row More Than Once
(http://www.sqldts.com/default.aspx?266)

Allan

Hi,

I'm building a DTS package and one of the tasks it needs to do is to
transform an existing order table in this format:
UserID OrderID
1 0010, 003c, 0145
2 045, x15
3 x9010
to a table of this format:
UserID OrderID
1 0010
1 003c
1 0145
2 045
2 x15
3 x9010
How can I use DTS to transform a single role from the source into
multiple rows in destination? Should I use ActiveX Scripting?

Thanks,
ywb

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Transforming Into Multiple Rows

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Transforming Into Multiple Rows - 10-26-2005 , 05:04 PM

Re: Transforming Into Multiple Rows - 10-26-2005 , 05:26 PM

Re: Transforming Into Multiple Rows - 10-27-2005 , 01:21 AM