Odd as it sounds, I am converting a SQL 2000 DTS package to SQL 7. I have an execute query task that executes a stored procdure with input and output parameters. In SQL 2000 this is not a problem, I can assign the output to a Global Variable, but how do I do the same in SQL 7? I am fine with using an ActiveX script to assing the input variable, but how do I capture the output of the stored procedure in a global variable?

Thanks in advance,