Post reply

Send an email if a child package called from an execute package task fails

  • June 2, 2009 at 7:37 am

    #131616

    I need to send an email and close the parent package down if a child package called from an execute package task fails. Any ideas please?

  • June 9, 2009 at 3:36 am

    #1006538

    Anyone able to assist here please?

  • June 10, 2009 at 5:49 am

    #1007284

    Griffster (6/2/2009)

    I need to send an email and close the parent package down if a child package called from an execute package task fails. Any ideas please?

    This should be easy. Connect the execute package task with send mail task, using fail constraint. When you connect two tasks with constraint, it setups on success constraint by default. You can change the type by right-clicking on the constraint and setting it to Failure.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • June 10, 2009 at 5:51 am

    #1007285

    That's great thanks. Much obliged. I should have known that one really! lol

Viewing 4 posts - 1 through 4 (of 4 total)

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