DTSglobalvariable to SQl query?

[forhead]

How do I pass a SQL query result(a single integer value) of one DTS step to another?
I know I have to use globalvariables, however, it seems that globalvariables can only be accessed by ACtiveX scripts , not SQL query.
Thanks in advance.

Aja

 

[nigelrivett]

You can use a global variable by using ? (and it sometimes works) but I prefer to set the source query in an activex task before the queery.
see

http://www.nigelrivett.net/SetDTSRunTimeValues.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.