Results 1 to 8 of 8
  1. #1
    Join Date
    Aug 2003
    Posts
    29

    Angry Unanswered: DTS - On Failure send mail does not work

    Hi

    Task A is a Execute Package task, and Task B is as Send Mail task. They are connected with a 'On Failure' connection.

    The problem is that when task A fails, task B is not run. Why?

    I have enabled and disabled the 'Fail package on step failure' for task A and it's 'child' in every way possible. I allowed transactions, and then tried again with them of...

    Suggestions?

    Thanks in advance.
    __________________
    Joćo Marto
    Joćo Marto

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Have you verified that the event is in fact failing ? Create an on success flow with the same step and see what happens.

  3. #3
    Join Date
    Aug 2003
    Posts
    29
    With on success it works... but the log status of the task is failled!

    How can that be???
    Joćo Marto

  4. #4
    Join Date
    Sep 2003
    Posts
    212
    does this happen when ur failure step is the mail task? or it doesnt matter?

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Check if you have On Success report Failure.

  6. #6
    Join Date
    Sep 2003
    Posts
    212
    Try making Task B an activeX script or sumthin else and c if that works...

    also check in ur execute package task when the package fails ie, how many steps in the package need to fail for the package task to fail....i think the default is 4 steps but u shud check what it is for ur package

  7. #7
    Join Date
    Feb 2002
    Posts
    2,232
    Busy day - sorry for the delay. Modify the package's property to "fail package on first error" - I am referring to the package that you are executing in execute package.

  8. #8
    Join Date
    Aug 2003
    Posts
    29
    Originally posted by rnealejr
    Busy day - sorry for the delay. Modify the package's property to "fail package on first error" - I am referring to the package that you are executing in execute package.
    Thankyou very, very, much
    Joćo Marto

Posting Permissions

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