Force SSIS package to Fail when One of the parallel Tasks Fail

  • Hi ,

    Let me know how to resolve the problem

    There are two tasks Task A & Task B which runs parallely . Task B Runs less than 3 Seconds and Task A Runs more than 30 Min.

    If Task B Fails , the running Task A should stop and package Should fail to run .

    Thanks

    Surya sunil

  • Hmmm, seems difficult to do out of the box.

    Maybe you could add some task after Task B that kills the SSIS process in some manner, but that seems quite dangerous to me.

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

  • Just one more thought: if task B takes less than 3 seconds, what's the point of having them run in parallel?

    Just run task B before task A with a precedence constraint.

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

  • Actually , I simplified problem .. coming to real scenario ...

    Task A getting hanged ( Could not able to sort out solution) . As work around, Task B has been added , which runs for 5 min in loop by checking whether Package completed or not . If Package runs more than 5 Min , I am trying to fail package . If package runs successfully less than 5 min , loop will break .

  • sunil.mvs (7/31/2014)


    Actually , I simplified problem .. coming to real scenario ...

    Task A getting hanged ( Could not able to sort out solution) . As work around, Task B has been added , which runs for 5 min in loop by checking whether Package completed or not . If Package runs more than 5 Min , I am trying to fail package . If package runs successfully less than 5 min , loop will break .

    I see. Maybe you should start your questions with the actual scenario next time.

    There is no possible way to do this from within SSIS.

    Execute your package in a SQL Agent job and monitor its execution with another job.

    If you go over 5 minutes, kill the Agent job.

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

  • :crying:

  • Is this possible solution at high Level . PFA

  • sunil.mvs (8/4/2014)


    Is this possible solution at high Level . PFA

    It seems like it could work. Haven't implemented anything like this myself.

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

Viewing 8 posts - 1 through 7 (of 7 total)

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