Hi there!

My DTS task is to import several files and compare the data within a loop.

I found this very good example 246 on sqldts.com (thanks guys!) but there is
one problem I still have to solve.

I don't want to store the differences between the original and the new data
in a table but in a recordset in the memory (performance reasons).

How can I create a "temporary" recordset in VB-Scipt? Is there a way to do
that?

Thanx for your help.

PMP

In article <#ZELgrqrDHA.732 (AT) TK2MSFTNGP09 (DOT) phx.gbl>, Manu Pfitsche
<brundle (AT) freesurf (DOT) ch> writes
I would use an Execute SQL Task to get the recordset, which can then be
stored in a global variable. The Execute SQL Task supports output
Parameters. Just click the parameters button. An example that uses this-

How to loop through a global variable Rowset
(http://www.sqldts.com/default.aspx?298)
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

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