Combine Multi SSIS packages in Visual Studio 2008

jb428j
jb428j used Ask the Experts™
on
I have multiple SSIS Packages that export tables to .xls or .txt files. Does Visual Studio 2008 allow merging of packages so I don't have to run each one? If so, how do I go about doing this, can you point to a resource that will explain this.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You can have a "Parent" package call other packages. Would that work?

Author

Commented:
Not really what I am looking for. I would rather not have 20 packages to basically do the samething. I would like to be able to take Package B and merge it into Package A. That way, I can run one package to export multiple tables.
Reza RadConsultant, Trainer
Commented:
11/26 Forrester Webinar: Savings for Enterprise

How can your organization benefit from savings just by replacing your legacy backup solutions with Acronis' #CyberProtection? Join Forrester's Joe Branca and Ryan Davis from Acronis live as they explain how you can too.

Reza RadConsultant, Trainer
Commented:
create new ssis package, use one execute package task for each other packages.
then just you need to run parent package for all export process
There is no official merge tool, but you can copy and paste from package to package.

Author

Commented:
Using a "Parent" package isn't what I really wanted. However, after looking at a few more options it seems to be the easiest way. I was able to do what I wanted by adding different Destination Connection Managers and just copy pasting package B Execute SQL Task and Data Flow Task into package A. I just had to change my package B SQL Task Connection to the one in Package A.

Thank you all for the help.

Author

Commented:
Thank you guys for your answers. All those solutions would work. I split the points. HoggZilla, you basically nailed on the head for what I can do.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial