sql server dts: Properties dialog on Transform Data Task from Oracle hangs -- sql server dts

Properties dialog on Transform Data Task from Oracle hangs

Nils Magnus Englund
12/20/2004 12:50:35 PM

sql server dts:

Hi!

Whenever I create a transform data task which transforms data to and/or from
an Oracle database, it takes a very long time for the properties dialog to
appear when I right-click and select properties on the task - ranging from
15 to 40 minutes. Any ideas what this could be? It naturally makes
developing DTS packages for Oracle databases a big hassle... I use the
native Oracle ODBC driver.

Regards,
Nils Magnus Englund

Re: Properties dialog on Transform Data Task from Oracle hangs

Kornel Kasprzyk
12/21/2004 9:07:53 AM

Hi,
While working with Oracle databases I use the Oracle Provider for OLE DB.
It works without any problems and the transformations processes are very
fast.
I suggest You not to use ODBC driver to connect with Oracle database.
Rgds,
Kornel.

U¿ytkownik "Nils Magnus Englund" <nils.magnus.englund@orkfin.no> napisa³ w
wiadomo¶ci news:efCmfoo5EHA.2428@TK2MSFTNGP14.phx.gbl...
[quoted text, click to view]