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: the Size property has an invalid size of 0.
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?