02-11-04, 13:45 #1Registered User
- Join Date
- Feb 2004
- Hamburg, Germany
Unanswered: DTS ODBC Pump to Oracle Performance Issue
I am pumping data to an Oracle 22.214.171.124.0 Database via ODBC (Oracle 126.96.36.199.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