I have an execute SQL task that is running a stored proc that returns either
a 1 or a 0.......which I have declared as a char. Here is the code I have in
my execute SQL task.

declare @Result char(1)
exec usp_CheckFreeSpace @Result OUTPUT, ?
select @Result as StagingSpaceResult

I have the output parameter set up as a Row Value and point it to a global
variable which is a string, and it is not populating the variable. When I
run the stored proc in Query Analyzer it works fine. Any suggestions are
appreciated.

Thanks

Have you had a look at this article?

Global Variables and Stored Procedure Parameters
(http://www.sqldts.com/default.aspx?234)


"Andy" <Andy (AT) discussions (DOT) microsoft.com> wrote