| Allan Mitchell 2005-09-28, 8:24 pm |
| The best thing to do is turn on package logging, Agent step logging
also.
If that does not do it for you then read this
http://support.microsoft.com/?kbid=269074
You can also try logging on to the box as the Agent or proxy account and
try executing the package interactively.
allan
"Jim Abel" <JimAbel@discussions.microsoft.com> wrote in message
news:4B98E8BA-FD6A-4B51-B2C4- 4662CC0D6968@microso
ft.com:
> Can you provide suggestions of how to troubleshoot a DTS Package that when I
> launch it runs sucessfully but when it is launched from a scheduled job it
> fails.
> This package is a very simple one that clears a table, then copies data from
> an Oracle view into the table cleared in the previous step and finally
> manipulates the copied data into another table. The job always fails on the
> 2nd step where it needs to connect to the Oracle Database. I am using a
> Oracle OLE DB Provider a user name and password (similar to a SQL Server
> account) the tst connection says it's sucessful. I set the Job by using the
> DTSRunUI utility with a scheduled time.
|