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?
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?