DTS and Oracle

#1

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 ?

#2

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

Quote:

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 ?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS and Oracle

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS and Oracle - 10-18-2005 , 02:24 PM

Re: DTS and Oracle - 10-18-2005 , 03:14 PM