02-11-04, 12:45 #1Registered User
- Join Date
- Feb 2004
- Hamburg, Germany
Unanswered: DTS ODBC Pump to Oracle Performance Issue
I am pumping data to an Oracle 220.127.116.11.0 Database via ODBC (Oracle 18.104.22.168.0 ODBC Driver).
It takes 5:28 mins to transfer 42.000 datasets from MSSQL to Oracle
and 4 sec to transfer the same 42.000 datasets back.
Are there any configuration issues I should consider on part of MSSQL?
Thanks for any ideas