Post reply

issues connecting to oracle..

  • March 15, 2006 at 10:37 am

    #76504

    We have recently migrated to windows 2003 server. The oracle client is also installed on this server .We have a  DTS which pulls data from an oralce 9.2 server. The DTS runs fine by itself ( we remoted into the server and ran it on the server). However when we schedule it is a job or try running it in Query analyser with xp_cmdshell it gives anerror "DTSRun OnError:  DTSStep_DTSExecuteSQLTask_1, Error = -2147467259 (80004005)

       Error string:  [Microsoft][ODBC driver for Oracle][Oracle]

       Error source:  Microsoft OLE DB Provider for ODBC Drivers"

    The permissions on the oracle home etc look fine .. The id under which job is run has system admin level permissions.

    Can anyone please help!!

    Thx

  • March 15, 2006 at 12:16 pm

    #626878

    When you run the DTS package as a job you aer running it under a different user than when you log in directly to the DTS package. I forget what the admin role that is used by SQL Agent but that might be your issue. I have run into this in the past but can not recall how I resolved the issue off hand.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply