DTSRun error when run as scheduled job
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?
Re: DTSRun error when run as scheduled job
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
Re: DTSRun error when run as scheduled job
Jeez, I just noticed the post-date on the original message... Guess I am a
bit late, huh?
"8-)
Paul