I have a stored procedure and would like to get output from the params. I have declared two variables and have assigned the variables to output params in the execute query activity. I get the following error once I exectue it.
Execute query : String[1]: the Size property has an invalid size of 0.
Stored Proc:
declare @p5 int
set @p5=-1
declare @p6 varchar(1000)
set @p6='Query Invoice Header Successful (No Lines)'
exec sp_My_Stored_Proc @a,@p5 output,@p6 output
select @p5, @p6
What could be done to solve this issue?