Oracle Database Discussions

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!

Copy table from Ms SQL Server 2005 to Oracle with SSIS package

634367Jun 18 2008 — edited Jun 18 2008

Hi all
I am witting an SSIS package to copy 2 tables from Ms SQL Server 2005 to an Oracle 10g database.

Problem: I can only see the Microsoft OLDB Provider for Oracle and it is too slow. How can I use the Oracle ODBC in aMs SQL Server 2005 or building a .net SSIS package.

thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 16 2008

Added on Jun 18 2008

#database-and-application-migrations

4 comments

5,087 views