sql server dts: DTS Perfromance -- sql server dts

DTS Perfromance

Gary
4/21/2004 4:54:27 AM

sql server dts: Hi All

I am trying to track down some information regarding DTS
performance and best practices when performing a data
pump from SQL Server to Oracle 9i. I am specifically
looking at the maximum throughput achievable by DTS and
any documentation available on how to use DTS to ensure
the maximum possible throughput is achieved between SQL
Server and Oracle. Any tips, pointers or articles anyone
can provide would be appreciated.

Thanks in Advance.

Re: DTS Perfromance

Allan Mitchell
4/21/2004 1:40:52 PM

Typically I have seen mention that the drivers between Oracle and SQL Server
are perhaps not the fastest. A lot of people i see doing this export to
text file first then use SQL Loader on Oracle

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]