ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Bulk Loads from SSIS using ODP.NET

87139Oct 29 2007

I just posted a sample here
http://ssis.wik.is/Home
Showing how to build a custom SSIS destination that uses ODP.NET's Array Binding to perform high-speed loads of Oracle from SQL Server Integration Services.

FYI, and ODP.NET doesn't play very well in SSIS. I think the assembly needs to be marked with [ComVisible(false)] (like System.Data is). As it is, whenever you use an ODP.NET OracleConnection in SSIS, you get an exception in ReleaseConnection.

Mostly you want to use the OleDb provider from SSIS, so it's not a huge deal.

David

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 26 2007

Added on Oct 29 2007

#odp-net

0 comments

1,026 views