Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
randym
Starting Member
3 Posts |
 Posted - 2008-08-08 : 11:59:18
|
| 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. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-08 : 23:38:58
|
| You may need restart sql or even reboot the server. I saw similar before, had to reboot once lost connection between two dbs. |
 |
|
|
randym
Starting Member
3 Posts |
Posted - 2008-08-09 : 06:51:42
|
| Reboot did not help |
|
|
|
randym
Starting Member
3 Posts |
Posted - 2008-08-09 : 06:53:02
|
| It seems like it has something to do with the agent because it works fine if I just execute the DTS package. Even if I log into the enterprise manager with the same user as assigned to run the agent. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-09 : 20:24:16
|
| Then you can enable package logging and see what happens. |
|
|
|
|
|
|
Error with job running DTS with Oracle provider