sql server dts: Active X Tasks and Variables -- sql server dts

Active X Tasks and Variables

Skot Void
8/5/2005 11:08:07 AM

sql server dts:

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

RE: Active X Tasks and Variables

Vishal Parkar
8/5/2005 2:55:31 PM

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

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_addf_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.

[quoted text, click to view]

Re: Active X Tasks and Variables

Allan Mitchell
8/6/2005 9:26:05 AM

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.