Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185

    Unanswered: unable to Schedule a DTS package

    I have created a DTS package on the Client with 'sa' rights and this DTS package is writing some output file on the Client's machine. Whenever I run the package from the the DTS wizard(F5) it runs fine and generates the output file at the desired location on the Client's machine.But the same process fails to run whenever I try to schedule it to run under the EM with the following : "Error = -2147220421 (8004043B) Error string: The task reported failure on execution. "
    Please Help!

  2. #2
    Join Date
    May 2002
    Posts
    25
    scheduled packages run under the context of the sql agent startup account. make sure it has the proper privs to do what your script is telling it to do.

  3. #3
    Join Date
    May 2002
    Location
    Montréal, Canada
    Posts
    28
    I already meet this problem and solved it by writting data on another machine. The sqlserveragent account was set with the same properties on my two servers (same OS, same everything...) but it worked only on one... But helpimstuck is right: First ensure your sqlserveragent account has rights to right data.
    Data Climber

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •