Just wanted to mention that the master SSIS approach gave us a tremendous jump in terms of performance. The SQL job which used to take around 17-18 minutes no matter...

Another thing to consider is that the "for each" loop should continue processing files even if any Execute Package fails due to data issues. I made the ForceExecutionResult = Success...

The master SSIS package approach seems to be working! Thank you very much!

The main issue we had was related to the dtsconfig file which each SSIS package used. The dtsconfig...

Thanks for your responses! Some more information about our process.

Currently, each SSIS being called from the job checks for the presence of a particular file(each file has a different name)...