Do not simply guess your buffer limits. Use this formula to find your ideal DefaultBufferSize :
Pushing too many threads on a server that is simultaneously running heavy SQL queries can cause CPU contention, slowing down both the database and the ETL process.
Many servers operate with idle CPU cores during ETL runs. The 655 methodology forces aggressive multi-threading to ensure you get your money's worth out of expensive server hardware. How to Configure SSIS655 Exclusive in Your Environment
By default, SSIS sets EngineThreads to 10. For a 655 exclusive setup: Count the logical cores on your database server.
By taking control of these advanced properties, you can slash batch processing windows, reduce server strain, and deliver real-time data insights to your organization faster than ever before. If you would like to explore this topic further, I can: