I am assigning the results from a query into a global variable rowset and
then running another package and passing that rowset over.

Can I in the called package use the rowset within a Execute SQL Task rather
than having to loop through it programatically in an ActiveX.

Cheers

Not as far as I know. There is no "Rowset" source

--

----------------------------
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



"Spud_Monkey" <spudmonkey (AT) aol (DOT) com> wrote

In article <#IjMtvHxDHA.3436 (AT) tk2msftngp13 (DOT) phx.gbl>, Spud_Monkey
<spudmonkey (AT) aol (DOT) com> writes
Something you might like to look at is the DTSPackageDSO provider.

Search in Books Online for "DTSPackageDSO".

Personally I would take a step back and consider what really needs to be
done here, and see if things have just got a bit over complicated.

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

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