Introduction
This tip will help to give points to be considered while writing the logic in SSIS package as per the value returned in the OUTPUT parameter of the stored procedure..
Background
The question posted at http://www.codeproject.com/Questions/819503/How-to-pass-out-parameter-from-stored-procedure-to?arn=5 gave me the idea to write this tip.
Using the Code
Example for this tip is attached to it. Here, I would like to just give a brief idea about the things to be considered.
- Add "Execute SQL Task" to execute stored procedure and configure it as shown in below screen shots:
- Just to set the conditions in Precedence constraints, I have taken two data flow tasks. Connect these data flow tasks with Success Precedence.
- Configure these Success Constraints as shown in the below image:
Points of Interest
Always format the SQL scripts as per standards so it is easy to understand for all.
History
