DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3
  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

    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?

  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.


  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?


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
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.