Question about parameter passing

[dashllh]

Hi!
The workflow of my DTS is somewhat like this:
---------------------------
An ExecuteSQLTask ---> An ActiveScriptTask
---------------------------
The first task will run a procedure,which uses "Select @retval as ErrorCode"
to pass out a return value, and a global varaible "ErrorStatus" has been set
using the ExecuteSQLTask's right-click property to receive the
value.Then,the second task will check the global varaible.
My issuse is,there exist some situations in which the var "ErrorStatus" got
nothing,which should be impossible.
How could this happen?
Report post as abusive

[tbradshaw via SQLMonster.com]

Hello dashlh,

Is it possible that @retval is NULL, or never gets assigned? Or perhaps
you're assigning a string value to an INT global variable?

In my testing, an unknown value changes the Type to "Null" and Value to <not
displayable>

Perhaps you can give us more information about your ExecuteSQLTask.

Best Regards,
Tom

Thomas Bradshaw
Data Integration Services
MyWebGrocer LLC

Post by dashllh
Hi!
---------------------------
An ExecuteSQLTask ---> An ActiveScriptTask
---------------------------
to pass out a return value, and a global varaible "ErrorStatus" has been set
using the ExecuteSQLTask's right-click property to receive the
value.Then,the second task will check the global varaible.
My issuse is,there exist some situations in which the var "ErrorStatus" got
nothing,which should be impossible.
How could this happen?