Moving from MSAccess to DTS to read Oracle DB RRS feed

  • Question

  • User-781338610 posted


    Until recently I have been using MS Access to read data from an Oracle DB.  I have been told that I can now use DTS to access this oracle DB and create a SQL 2005 database.

    I have the ODBC connection detiails (server IP Address, username and password) - can anyone advise on how to create a connection within DTS?

    many thanks,


    Wednesday, August 24, 2011 4:57 AM

All replies

  • User269602965 posted

    ODBC is very slow.  Painfully slow.

    Consider a .net app to open oracle, bulk read into array, open MSSQL, and then bulk insert into MSSQL from the array.

    Do that like 5000 records each time.  Should be very fast.

    Wednesday, August 24, 2011 2:17 PM