Those of you that are using SSIS in conjunction with Oracle will have (or should have) read Donald Farmer's blog post that details some of the issues that you need to be aware of.
Donald himself states "I do not expect that Microsoft will write an Oracle fast loader - .... But on the other hand I do fully expect that there will be excellent Oracle loading capabilities from third parties, who may well live long and prosper in that market."
Well just such an Oracle loader now exists. It has been produced by Persistent and the stats are impressive. In tests it took nearly 5 hours to load 2m rows of data into Oracle when using the OLE DB Destination component that you get with SSIS. Using Persistent's loader the same dataset took a little over 2 minutes. Whichever way you cut it that is an impressive improvement.
Read more about the loader here: http://www.persistentsys.com/products/ssisoracleconn/ssisoracleconn.htm and here: http://www.persistentsys.com/products/ssisoracleconn/ssisoracleconn_features.htm
Great work Persistent!
-Jamie