Post reply

ssis parent and child packages

  • March 11, 2014 at 3:15 pm

    #396403

    Hi,

    I have a parent package which has a for each loop which executes 5 child packages. I want the master package to continue running (after sending error email) even if the ChildPackage1 fails. For the rest of the child packages, I want the Master package to fail in the event of the child package failure.

    I tried setting ForceExecution to Success on ChildPackage1, but even then it doesn't run the other child packages in the event of ChildPackage1 failure. My MaxErrorCnt property for foreachloop task on Master package is set to 1, as I still need to fail the package in the event of failure in Child packages 2-5.

    Please suggest.

    Thanks and Regards,

    Veena

  • March 11, 2014 at 3:17 pm

    #1696160

    The easiest solution would be to execute child package 1 in another loop, and connect it to your original loop with an OnCompletion precedence constraint.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 11, 2014 at 3:28 pm

    #1696162

    thank you for the quick reply.

    We kind of have a standardized Master Package layout and cannot make much changes to it. If there is anything I could do withing the ChildPackage1, that would be my first preference.

Viewing 3 posts - 1 through 2 (of 2 total)

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