SSIS .Net Provider Output Task

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@hotmail.com" wrote:

> 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
>
>