SSIS - Sequence container

  • Dear all,

    If I have a sequence container and inside it several tasks, only after all the tasks have been executed it will pass to the other tasks that are outside that sequence container?

    Also, can you please help me understand, if I have to tasks (that are not connected , meaning no precendence constraints between them) and one of them fail, by the fault the sequence container will pass the status failed for te next task, even if the other task was correctly executed?

    Thank you

  • river1 - Thursday, September 14, 2017 9:51 AM

    Dear all,

    If I have a sequence container and inside it several tasks, only after all the tasks have been executed it will pass to the other tasks that are outside that sequence container?

    Also, can you please help me understand, if I have to tasks (that are not connected , meaning no precendence constraints between them) and one of them fail, by the fault the sequence container will pass the status failed for te next task, even if the other task was correctly executed?

    Thank you

    I'm pretty sure you have it correct as to the "default" behavior.   Also, when there are no precedence constraints for two or more objects within a Sequence Container, they will all execute at the same time, so be careful what you put in there or you could potentially block yourself.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • Thank you

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

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