Hi,

I have a DTS that I am writing in SQL Server 8.0.

This is what I have: I am writing an Active X Script
Transformation. I want to create from my source table,
two columns in my destination table. I want to be able to
have the DTS run through the first part of my code, and
then tell it to create a new line in my destination table
to start with. And then have it continue with the rest of
my code on the second line. So when the DTS Active X
Script was done, there were two lines in the destination
table for each line in my source table.

Can anyone help me?

Thanks in advance,
Megan

You are probably going to best served by implementing this routine in an
Active Script task and opening the file up there. You can then read your
data source and loop through the recordset. At each iteration you insert
your own line.

That said you could use the Multi Phase Datapump in DTS to implement this

Multiphase Data Pump (Field Notes)
(http://www.sqldts.com/default.aspx?282)

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Megan" <anonymous (AT) discussions (DOT) microsoft.com> wrote