Post reply

Execute Package Task failing even though dtsx package it calls had a failure that was corrected

  • July 29, 2014 at 9:24 pm

    #297205

    I have an ssis package called 'master scheduler' which has an Execute Package Task that kicks off a child dtsx package.

    The child dtsx package has a sequence container with 3 unique task flows:

    task420 -> task420 retry -> send mail task

    task421 -> task421 retry -> send mail task

    task422 -> task422 retry -> send mail task

    That way if task420 fails first time there is a retry effort. Same goes for task421 and task422.

    Most of the time tasks succeed on first try and sequence container goes green and master schedule proceeds with remainder of control flow.

    But, whenever any of the tasks require a second attempt before succeeding ie. sequence container turns green, the Execute Package task in the master scheduler package fails.

    I need the Execute Package Task not to fail if the sequence container in the child package shows success. What I've tried; set maxErrorCount to 3 on Execute Package Task. How to configure it so Execute Package Task is tolerant of failures in the child package that it kicks off?

    --Quote me

  • July 30, 2014 at 12:32 am

    #1733468

    Take a look at this blog post: Continue Loop after error - Part II.

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

  • July 30, 2014 at 5:13 pm

    #1733871

    Thanks a lot Koen

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

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