Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Posts
    58

    Unanswered: Passing error description to failure task in DTS

    In my DTS package, is there any way to pass the task name and error description to another task that gets called on the task's failure?
    Last edited by WhiZa; 08-16-04 at 11:29.

  2. #2
    Join Date
    Aug 2003
    Posts
    9

    Half the answer?

    Quote Originally Posted by WhiZa
    In my DTS package, is there any way to pass the task name and error description to another task that gets called on the task's failure?
    I have a bunch of packages that implement the same "on error" task as an Execute Package Task (in other words, my error handling task is its own seperate package). In each package that implements that error task, I set a global variable with the task name whose failure I'm trapping. Then in the error handling task I read the value of the global variable to fill an email notification.

    If I knew how to trap the actual error, either in a global variable or with script, I'd stick that in a global variable and do the same thing, so maybe if someone knows how to do that...

Posting Permissions

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