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?

look at output parameters for SSIS tasks: sqlshack.com/…

Alex
– Alex

2022-03-02 18:14:31 +00:00
Commented Mar 2, 2022 at 18:14 — Alex
– Alex, Commented Mar 2, 2022 at 18:14

Hadi · Accepted Answer · 2022-03-02 19:20:12Z

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

answered Mar 2, 2022 at 19:20

Hadi

37.5k13 gold badges73 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related