This runs every Monday via sql agent job scheduler.

If this is part of a larger package, how long does the total package take?

It is actually one of the 10 child...

To respond to your previous statement, initially after you suggested, I used the AutoAdjustBufferSize setting (set it to True) which by default gave me DefaultBufferMaxRows= 10000 and DefaultBufferSize= 10MB. which...

@Jeffrey Williams

Actually this is an SSIS solution consisting of 10 packages run by a master package. The functionality currently in place is Truncate and ReLoad of staging tables from the...

Hello @Jeffrey Williams,

Thanks a lot for your advice and suggestions. It helped me immensely. I did iterations for different combinations of DefaultBufferSize, DefaultBufferMaxRows and the number of output paths from...

I tried with Balanced Data Distributor and now the elapsed time is 50 seconds. Screenshots attached

But I had to create 30-32 branches as shown in the screenshot which is inconvenient....