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 |
|
rushdib
Yak Posting Veteran
93 Posts |
 Posted - 2004-07-26 : 09:08:33
|
| We have a DTS package that transfers data from SQL to Oracle. If I execute the package, the package completes successfully but when I schedule it, it fails. From the EM there is no way I can fgure out what caused it. How do I track the error? Is there a way I can modify the package to include a task to log the error?Thanks in advance,Rushdi |
|
|
JasonGoff
Posting Yak Master
158 Posts |
Posted - 2004-07-26 : 10:09:44
|
quote:
If I execute the package, the package completes successfully
This is because the DTS package is running under your Domain ID (assuming NT Authentication for connections)quote:
but when I schedule it, it fails.
Because it will be running under the domain account of the SQL Server service (as far as I know). Does the Domain Account that SQL Server uses have access to the Oracle system ? |
 |
|
|
|
|
|
tracking job failure errors