The solution is to write the SQL statement as

EXEC ?= usp_myStoredProc ?,?

and set the parameters as Param0 = ReturnValue, Param1 = Input, Param2=Input and assign Param0 to the variable you want to carry through.

Thanks to everyone for the help offered