Post reply

Task is now failing - it worked yesterday

  • June 17, 2005 at 10:17 am

    #566500

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

  • June 17, 2005 at 10:25 am

    #566501

    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 17 (of 17 total)

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