I am working on performance improvements uploading to Oracle. The
performance of the Oracle OLEDB provider and MS Oracle OLEDB provider
are really poor. 12 minutes to load 50,000 rows.

I want to see how the .Net Provider for Oracle performs.

I have started to create a SSIS package. I have created the Connection
Manager for a .Net Providers\Oracle Client Data Provider. I want to
create the Data Flow Destination, but I do not see a choice in the
Toolbox that will push to the Connection Manager I created.

How do I get SSIS to output to the Oracle connection I have created?

Thanks,
Norman

Microsoft has admitted to failing us on the performance when loading to
Oracle. This is a well known issue, they have however endorsed Persistent
Systems 3rd party Data Flow Destination.

http://www.persistentsys.com/product...oracleconn.htm

Almost makes me want to switch back to SQL Server 2000

"nite_eagle (AT) hotmail (DOT) com" wrote: