Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
 Posted - 2001-06-01 : 11:05:48
|
| We have a DTS package using OLEDB for SQL Server 7 that transforms data to Oracle 8.1.5 via an OLEDB connection. It is very slow (32 minutes for 72000 records). There are no special conversions going on it's just a simple copy table transformation. How can I tune this to make it pump faster? Thanks in advance...DanielSQL Server DBA |
|
|
|
|
|
DTS to ORACLE using ORACLE'S OLEDB Drvier