Hi,

I am using SQL Server 8.0, and am using an ActiveX
script. I have a source that for every row in that table,
I need to put two rows in the destination. Is there a
command that allows me to add a new row in the middle of
the ActiveX script.

So, I would have code to make one row, and then a command
to post the first row and create another row. Then code
to fill the other row.

So, in the end if I have 4 rows in the source, I will have
8 rows in the destination table.

Can anyone help?

Thanks in advance,
Megan

You posted this exact same message yesterday as "DTS New Line".

See my reply there.

--

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

Sorry about that. The first message didn't show up for
over 5 hours on my computer, and I didn't think that it
posted correctly. So, I submitted it again.

Sorry for any inconvenience.
-Megan