How to use output parameter in SSIS execute sql task from a stored procedure

Question

Using a parameter, @IsSuccess in stored proc. How to use that @IsSuccess parameter in SSIS Execute SQL Task and take that as output from that component to another component?

Answer 1

You should use the following SQL statement in the Execute SQL Task to store the stored procedure output into an SSIS variable:

EXEC mystoredprocedure ? OUTPUT

Then in the Execute SQL Task editor, go to the parameter mapping form and select the SSIS variable you need to store that value.

More details can be found in the following article:

• Execute SQL Task in SSIS: Output Parameters vs Result Sets

After storing that value, you should use this variable within the precedence constraints expressions:

• Overview of SSIS Precedence Constraints