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 Chriss Miller 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
Joined
May 6, 2003
Messages
49
Location
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