MS SQL Server DTS - DTS and Oracle

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

DTS and Oracle

David J. Cartwright

2005-10-27, 7:57 am

I am using DTS on SQL Server 2000 SP4 to get ~100K rows from an Oracle 9i
db, it is slow.
Anyone know of any articles with info on how to optimize Oracle to SQL DTS ?

Allan Mitchell

2005-10-27, 7:57 am

Hello David,

A lot of people have this problem. A number of them do this

Export to text file
FTP
Import on the SQL Server using BULK INSERT.

Which driver are you using? You may want to experiment.

Have a google and see what others are doing.

Allan

> I am using DTS on SQL Server 2000 SP4 to get ~100K rows from an Oracle
> 9i
> db, it is slow.
> Anyone know of any articles with info on how to optimize Oracle to SQL
> DTS ?

Sponsored Links