|
Home > Archive > MS SQL Server DTS > October 2005 > Transforming Into Multiple Rows
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Transforming Into Multiple Rows
|
|
|
| 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
| |
| Allan Mitchell 2005-10-27, 7:57 am |
| 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
| |
|
|
Yes! That worked!
Thanks Allan.
"Allan Mitchell" wrote:
> Hello WB,
>
> You can use this
>
> Processing The Same Row More Than Once
> (http://www.sqldts.com/default.aspx?266)
>
>
> Allan
>
>
>
>
>
|
|
|
|
|