Automating Multiple Package execution

Hi,

Can anyone tell me the process of executing multiple packages in SSIS

I have 10 packages which should be executed in an order and should be automatically executed once in a day.

Can someone suggest me any such process which will help me to achieve this

Regards,
Explorer

You can build a main package that integrates the other packages in sequence and then create a job that executes the main package when you want in a schedule.

Regards,

Raul

|||

Hi,

Can anyone tell me the process of executing multiple packages in SSIS

I have 10 packages which should be executed in an order and should be automatically executed once in a day.

Can someone suggest me any such process which will help me to achieve this

Regards,
Explorer

As Raul said, you can achieve this with one master package which in turn calls the other 10 packages in the sequence you desire.

1) Create a new package and add 10 Execute Package Tasks in your Workflow.

2) Configure each Execute Package Task to call the package you want in order to get the right sequence.

3) Schedule a job to run the master package.

sql