DTSRun error when run as scheduled job


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: DTSRun error when run as scheduled job

Hybrid View

  1. #1
    sharonc Guest

    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?
    Share on Google+

  2. #2
    Paul Mc Guest

    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

    Share on Google+

  3. #3
    Paul Mc Guest

    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
    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center