Hi,

I'd like to know if I could use a SQL task to actually load values into
Global variables, or am I just missing something? I understand how to use
them as passed in arguments to a task, but is it possible to update them
back?

Can you the results of a SQL task into a global variable or is it VBScript
only? How would you access it from another SQL Task?

Can VBScript Tasks use an already created Connection object, instead of
having to build one inside vbscript?

Thanks in advance,

Are you looking for something like this

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

Results of an SQL task can be read into a Global variables yes - look
for the parameters button.

No. You cannot point a connection in DTS to a connection in VBScript.
Sure you could substitute in the properties from the connection and use.



"Gary" <clgary (AT) yahoo (DOT) com> wrote