DTSRun error when run as scheduled job

[sharonc]

I get the following error when I try to run the DTSrun utility as a scheduled
job:

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 sql Server agent is in the sysadmin group and has all
rights to the database. Can any one help?

[Paul Mc]

G'day Sharon.

Well, the Timeout Expired seems to be the key...

I would start by taking a look at either:
A) The Login Timout property on the SQLAgent, or
B) The command timout property on each step object in the task.

They are the only places that I can think of offhand which could cause any
kind of timeout problem. Let us know if you have any luck.

Cheers,
Paul

[Paul Mc]

Jeez, I just noticed the post-date on the original message... Guess I am a
bit late, huh?
"8-)

Paul