Last post Aug 24, 2011 02:17 PM by Lannie
Aug 24, 2011 04:57 AM|fiorano|LINK
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?
Aug 24, 2011 02:17 PM|Lannie|LINK
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.