While searching through google for performance tips on SSIS / DTS 2005, I came across Ashvini Sharma’s blog.

There’s a number of great entries dealing with package execution and ways you can improve your throughput. Checkout the entry on DefaultBufferMaxRows and DefaultBufferSize.