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.