I'm making DTS packages...

So if I have a Connection, and Execute SQL Task, and then I want to use an
Active X script to do more things.

How do I get the SQL results from the EXCUTE SQL task in to the active X task?
For example: Variables I have filled in the sql task, or Cursors I have
filled there.

Thanks everyone!
--
SKOT VOID
1010011010

If i understand you correctly, you can refer to following url which has
example similar to your requirement.

http://msdn.microsoft.com/library/de...df_ax_06er.asp

Refer to "Using a Global Variable that Contains Columns of Data" and "Using
a Global Variable that Contains a Rowset" section.

--Vishal.


"Skot Void" wrote:

This article should give you ideas.

How to loop through a global variable Rowset
(http://www.sqldts.com/default.aspx?298)

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Skot Void" <SkotVoid (AT) discussions (DOT) microsoft.com> wrote