Error when using Microsoft OLE DB for Oracle in DTS Package
I have a DTS package that use the MS OLE DB provider for Oracle. The DTS package executes stand alone; but when placed in a schedule job, it won't run. This was working; but quit after I had detached some databases to copy them. After re-attaching them, the jobs would no longer run. I have logged into the Enterprise Manager with the same credentials as what the SQL Server agent uses and that user can execute the DTS package successfully. But the job will not run it. The message I get is: Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed. Again this only happens when the job tries to execute the DTS package.
Software/Hardware used:
Software/Hardware used:
ASKED:
August 5, 2008 9:53 PM
UPDATED:
September 20, 2008 11:01 PM
Answer Wiki:
When you run the job manually are you doing it on the servers console or on your workstation?
Can you use the Oracle tools to connect to the Oracle server manually?
Microsoft KB Article <a href="http://support.microsoft.com/kb/255084">255084</a> should help you out.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
