Greetings,

Sorry for a somewhat long post, but it ends with the specific question about
how to exec a DTS package with an Oracle driver.

We have several DTS packages that connect to Oracle by ODBC and/or OLEDB
(microsoft drivers). In moving them to SQL 2005 ( using 64-bit o/s (AMD x64)
and 32-bit SQL) they are getting the following error:

The Error in pertinent part is ORA-06413: Connection not open.

In reading through discussion groups, it appears this is related to the path
of sql server on 64-has a parenthesis in the path: C:\Program Files
(x86)\Microsoft SQL Server\90.

For more information, the post was:
http://forums.microsoft.com/MSDN/Sho...59581&SiteID=1

The fix suggested by oracle was
"Find the location of the application that is generating the error. Check
the path to this location and see if it contains any parenthesis. If so, you
must relocate the application to a directory without any parenthesis in the
path."

However, if I'm using DTSRUN, how do I move the path of it? Some information
shows that DTSRun has been dropped and instead to use command line of DTExec,
but I couldn't get that to work either.

Any ideas would be appreciated!

tks,
-Steve M/ Portland

After posting, I found it works by moving the dtsrun.exe as follows:

The problem was that Oracle doesn't like parenthesis in the path as in:
C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\DTSRUN.exe

So I copied the dtsrun.exe to a non paran path, and use the fully qualified
path in the job:
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\DTSRUN [then the
switches].

Hope this helps someone else!


"smoss" wrote:

thanks smoss... Upcoming duties for us will be to migrate dts which reading
from Oracle to sql25k so that..
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''''s hard to provide information
without seeing the code. location: Alicante (ES)


"smoss" wrote: