Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to set output Global Variable in a SQL Task and read it from Activ

Status
Not open for further replies.

swetab

Programmer
May 6, 2003
49
0
0
US
How to set output parameter value for Global Variable in a SQL Task and read it from ActiveX script

DECLARE @ErrOutputMsg varchar(50)
exec SE_LOAD @ErrOutputMsg OUTPUT
Select @ErrOutputMsg AS OutTest

Then I go to Parameters- Output parameter - select Row value - pass this output parameter to the global variable

OutTest to output global varibale "ErrorMsg"

But when i use try to get the value for global variable from ActiveX script it returns blank or anything that i specified for global variable value for "ErrorMsg"

What is wrong?

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top