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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!