Call multiple ssis packages and execute them from master ssis package

Question

Call multiple ssis packages and execute them from master ssis package

dallas13

SSCertifiable

Points: 7491
More actions
March 5, 2010 at 3:21 pm

#145693

Hello
I have few SSIS packages located in some folder. They should execute in certain oder one by one.
I want to create one master SSIS package that will go to that folder and grab packages and execute/run them
one by one (no repeat). What is the best/easiest way to design such SSIS package?
Thanks

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Steve Cullen SSCertifiable Points: 5598 More actions · Answer 1

You can use a sequence of Execute Package tasks with success connectors. That will make sure you execute the tasks in the sequence you require.

Converting oxygen into carbon dioxide, since 1955.

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 2

You could build a ForEach Loop with a package exec task in it to execute them, then you would need to name them so that they were retrieved in the order you wanted.

Another way would be to create a table that contained the order you wanted and then you populate an SSIS variable with the recordset and use that to feed the order and the list to a ForEach loop just like I mentioned before. The only difference would be the source of the list.

CEWII

arleneaquino_01 SSC Enthusiast Points: 111 More actions · Answer 3

Hi,

I'am also having a hard time in figuring out how to use multiple package configurations for only one package.

ex. one config for specific brand, then another config for other brand but only one package

How can the package know what config he needs to execute? if there's multiple configurations?

Please help me. thanks.

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 4

With an Exec Package you really can't. But that doesn't mean it is impossible. Please look at these articles, they may give you some insights:

http://www.sqlservercentral.com/Authors/Articles/Elliott__Whitlow_/483442/[/url]

CEWII

arleneaquino_01 SSC Enthusiast Points: 111 More actions · Answer 5

Hi,

Thanks. I'll study that.

By the way, what's the different uses of package configuration type and what's the best to use?

thanks

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 6

Their general purpose is to give parameters to a pacakge at run-time.

As for best, that is quite variable. I personally like config files and SQL Server storage, but don't like environmental variables.. I don't think I can go with a best..

CEWII