Geek Answers Handbook

Why is my failure not triggered when an SSIS sequence container fails?

I have several containers of the SSIS sequence, and if any of the tasks do not work in them, I want to direct the thread to the SQL task, which cleans everything so that I can solve the problem and start it again without duplicate data. My problem is that I cannot get the thread directed to the SQL task, even if something in one of the sequence containers fails. It seems like this should be the default behavior, but there should be some kind of setup I am doing. I played with setting FailParentOnFailure, but all this means that the rest of the package is not running. I would insert an image to help understand what I set up, but I think my reputation is not good enough yet .: P

+7
source share
4 answers

I think that this is definitely one case where the picture would help others answer my question. I had 3 sequence containers, all pointed to the same SQL task if they failed. I wanted the SQL task to be executed if ANY of the sequence containers had an error, so the priority restrictions had to be set to logical OR, otherwise it would never work if all 3 failed. Changed it to OR, and it worked the way I wanted.

+19
source

Make sure you click “Change” to “Constraints” and change the last part for several restrictions to OR so that if one of them does not complete the task, otherwise it will wait until all of them fail.

+4
source

Check the sequence container property if FailPackageOnFailure = true, it will not trigger a "failure priority restriction".

+2
source

Without additional information about your Sequence containers, it’s hard to be sure of the problem.

I would try to check the Propagate system variable of your containers. Whenever you have a task that could fail, and you do not want your entire package to stop, make sure that you do one of the following:

  • Go to Event Handlers and do something in the OnError event to handle the failure or
  • Set the Propagate System variable for this task to False

I would provide some screenshots, but for this I do not have enough reputation. Instead, I will leave you with some links with more information on this:

Similar to your question: http://sqlserverselect.blogspot.com/2010/12/ssis-foreach-loop-container-continue-on.html

Event propagation details: http://simonworth.wordpress.com/2009/11/11/ssis-event-handler-variables-propagate/

+1
source

More articles:


All Articles