I´m using SQL Server 7 and DTS to insert some data from a survey.

The data is like this, using n products:

form_id, section_name, product1_id, product2_id, product3_id, product4_id,
.... product1_role, product2_role, product3_role, ... etc.

I want to convert it to :

section_id, form_id, section_name, product_id, product_role, etc.

and insert n rows in the destiny from one row in the origin.

Is this possible ?

--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

You could adapt this article

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

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Nicolay" <ngiraldo (AT) colomsat (DOT) co.net> wrote

El Vie, 10 Oct 2003 22:26:41 +0100, Allan Mitchell
<allan (AT) no-spam (DOT) sqldts.com> escribió:

It works, now, how can I put the data in several tables in a single
transformation?

--
Nicolay Giraldo

You can use lookups

How to Use Lookups in DTS
(http://www.sqldts.com/default.aspx?277)

--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org




"Nicolay" <ngiraldo (AT) colomsat (DOT) co.net> wrote