Hi,

i have a ExecuteSQL-Task thats Select some Data from a Source-Connection and
store it in a Global Variable as a Recordset.

Now I want to simply put the whole Data in a table with a different
connection. The only way I know it works is with an ActiveX-Task and a
ADO-Recordset.

Now the QUESTION: Is it possible to do this with a second EXECUTESQL-Task ?
(Insert into...) ?

Thanks,
Matthias

In message <#T3ILthMEHA.2704 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, Matthias
<spame (AT) mkrause-it (DOT) de> writes

Can an Execute SQL Task consume an ADO recordset? No, I'm afraid not.
The Exec SQL Task global variable rowset/recordset deal is one way.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org