I have a stored procedure which has one input and two output parameters. I am calling the parameter from within a DTS package with the following statement:
DECLARE @Output1 int, @Output2 int
EXEC dbo.MyProcedure input, @Output1 OUTPUT, @Output2 OUTPUT
SELECT @Output1 AS Output1, @Output2 AS Output2
When selecting the Parameters button and going to the Output Parameters tab and selecting Row Value, there are no selectable parameters. Instead it states "Settable Database Options:"
The stored procedure does return the output values when executed outside of the DTS package.
Thanks for your help,
Eli