nerdiness devours me

A great MSDN article about how you can squeeze the best performance out of your package dataflows.

Update: I just found some more performance tuning articles while doing some research on other SSIS related stuff.

Optimizing SSIS Package Performance Part 1 and Part 2 describe whats going on under the hood of the two main engines of SSIS: the runtime and the data-flow engine.

Execution plans can tell you how a query will be executed, or how a query was executed. They are, therefore, the DBA’s primary means of troubleshooting a poorly performing query.