SSIS performance

Hi,

I have 4 execute packages say A, B, C, D. These packges contains packages for data transfer in turn.

Package A - 15 packages

Package B - 15 packages

Package C - 20 packages

Package D - 20 packages

When i run these packages one at a time in the order A, B, C, D then the execution time is around 17 mins.

If I make a parent package and put A, B, C, D in sequence in it, executing this parent package increases the execution time to arnd 50 mins.

Pacakge A, B, C, D doesnot run in parallel. They run one at a time. So i was wondering why the there is so much time difference.

Please let me know if theres some configuration settings to make the parent package efficient.

All the test conditions are same in both the cases. The source and the target are SQL server which are on the same machine as the SSIS.

Thanks,

Vipul

Hi Phil,

I am using SP2.

Yes, I am passing variables from parent to child packages.

Inserting data takes very less time. But Post Execute is taking lot of time, major chunk of time is gone in this only.

Thanks,

Vipul

Hi bkallich,

The runtime has decreased a lot. The whole package is executing in 13 mins.

Thanks for the help!

Vipul