Sql server stored proc returns empty array w JDBC adapter

I have a SQL Server stored procedure that I need to call. When I view the parameters for it in an ODBC client I have it shows that it has 1 paramter of type ‘Return Value’ and 4 of type ‘Input’.

So in the JDBC adapter I created a stored procedure call operation. On the CALL tab I created the parameters and ran the integration. I received an error stating ‘too many arguments specified’.

I deleted the 1 output parameter for the Output Field and moved it to the RESULTS tab. The integration calling the stored procedure now executes properly but the ouput parameter is an array of length 0.

I’ve talked to the developer who wrote the stored proc and he is setting the return value. I’m not sure what else to do? Suggestions?

aww