Task is now failing - it worked yesterday

  • And the job *owner* did not become an issue ....

  • Looks like it was an issue on the source server.  I recreated the DTS job exactly and it failed the same way again. 

    I added an ORDER BY clause to the sql used to pull the data off the source server and it works now. 

    Not a very descriptive error coming out of DTS, but it's working now.

    I still do not know why it would work when I manually ran it, but it wouldn't work when it was scheduled.

     


    Live to Throw
    Throw to Live
    Will Summers

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply