sql server dts: DTS runs when Manually launched but fails when Job launches it -- sql server dts

DTS runs when Manually launched but fails when Job launches it

Jim Abel
9/28/2005 1:17:03 PM

sql server dts: 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

Re: DTS runs when Manually launched but fails when Job launches it

Allan Mitchell
9/28/2005 9:33:50 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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.