Many customers are unhappy that SSIS performance is slow slow slow when inserting to Oracle. Donald Farmer sets outs a few of the reasons for this here: http://www.sqljunkies.com/WebLog/donald_farmer/archive/2005/03/13/8819.aspx
A guy called Scott Barrett whom is fairly prevelant on the SSIS forum had some issues with this and trialled a high speed Oracle OLE DB Provider to be used for the insertions as provided by Persistent. Scott's insertion of 600000+ records that was taking 206 minutes when using the Microsoft OLE DB Provider took 24 seconds when using Persistent's driver. Which is very impressive indeed.
Contact Sidharth at Persistent (sidharth[at]persistent.co.in) for more information.
-Jamie