September 2, 2008 at 6:29 am
Hi Everyone,
I've been using DTS, and will be using SSIS soon, I'd like to make an enquiry about it's features.
Can someone please tell me whether it is possible to create dependent packages in SSIS ? that is, Package A executes, only when it is done finishing then Package B runs, and then when this is done Package C starts. Is there some way of doing this ? or do I have to create a script to make each package run when the previous one has completed ?.
Thanks in advance,
Regards,
Veronica
September 2, 2008 at 6:48 am
You can do this in a lot of ways with SSIS / SQL Server.
First, if you have several independant packages, you can schedule them using the SQL Job agent. If each package is a step in a job, you can specify each step to run if the previous step completes successfully.
Within SSIS, you can call a package from another package. So, you could create a package that contains several Execute SSIS package components and use the control flow to specify the order in which they run and what to do if they fail.
You could also take the contents of each of the packages and create one big package. Within the one big package, you could use the control flow to specify which pieces to run in which order and what to do if there is a failure.
September 2, 2008 at 7:06 am
oh thank you for this. I'll look at each option, and test them out.
Regards,
Veronica.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply