paultran00
asked on
In SSIS 2008, can packageA call packageB ?
Hi,
I'm using SSIS 2008.
I have 2 ssis packages.
QUESTION:
1. can packageA call packageB ? How (please show example code)?
2. Will packageA task that executes packageB wait until packageB is completed before packageA goes on to process a subsequent task?
Thanks.
I'm using SSIS 2008.
I have 2 ssis packages.
QUESTION:
1. can packageA call packageB ? How (please show example code)?
2. Will packageA task that executes packageB wait until packageB is completed before packageA goes on to process a subsequent task?
Thanks.
Hi,
1-Yes, use "execute package task", try to figure it out yourself, it's straight forward, then google "ssis 2008 parent child packages" for hundreds of examples if you're stuck.
2-Yes, it'll run when A finish, it'll be treated as a regular task that runs after a success or failure of the superseding task, using "Precedence constraints". and also you can pass parameters and values from parent to Child.
1-Yes, use "execute package task", try to figure it out yourself, it's straight forward, then google "ssis 2008 parent child packages" for hundreds of examples if you're stuck.
2-Yes, it'll run when A finish, it'll be treated as a regular task that runs after a success or failure of the superseding task, using "Precedence constraints". and also you can pass parameters and values from parent to Child.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Earlier link available from Microsoft as they pulled down (almost) anything prior to 2014 is here https://docs.microsoft.com/en-us/sql/integration-services/control-flow/execute-package-task?view=sql-server-2014 but same applies for 2008.