Try to use Transact-SQL conversion in your SSIS packages when you have several million rows!
Why? Just read this article! 🙂
The results (30 million rows):
Baseline = 35 sec
Transact-SQL conversion = 46 sec
Conversion on the OLE DB Source component = 45 sec
Data Conversion transformation = 49 sec
Derived Column transformation = 71 sec