DTSRun Error when run as scheduled job

[sharonc]

When I try to run my DTS as a scheduled job with the dtsrun utility, I get the following error:

DTSRun: Loading... Error: -2147008507 (80074005); Provider Error: 0 (0)
Error string: Unspecified error
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts.hlp Help context: 713 Error: -2147467259 (80004005);
Provider Error: 0 (0) Error string: Timeout expired
Error source: Microsoft OLE DB Provider for SQL Server Help file:
Help context: 0

I have verified that sqlagent has full permission to the database. Can anyone help?

 

[tlbroadbent]

Check out the article "INF: How to Run a DTS Package as a Scheduled Job" at

http://support.microsoft.com/support/kb/articles/Q269/0/74.ASP

Terry

http://members.home.net/tlbroadbent/index.htm

 

[sharonc]

I went through that document and I don't see anything I need to do different. I still have the problem.

 

[tlbroadbent]

Is the SQLAgent running as a domain or lacal account? Terry

http://members.home.net/tlbroadbent/index.htm

 

[tlbroadbent]

I forgot to ask. Which version of SQL Server and which service packs are installed? Terry

http://members.home.net/tlbroadbent/index.htm

 

[sharonc]

Thank you for your help. I fixed my problem by changing the owner of my scheduled job to the name of the same person as sql server agent is connecting with. Now it runs ok.