September 29, 2010 at 11:06 am
I have several sequence containers which have 3 DataFlow tasks and an ExecuteSQL task. Each Sequence container I have set the MaximumErrorCount to 10 as well as set each sequence Contaniers child tasks to a MaximumErrorCount to 10. The behavior I want is if any of the tasks inside the Sequence Containers fails it will proceed to a SendEmail task, which I have each Sequence contaners on fail path points to. Then I have set the Oncomplete path to the next Sequence Container. So that if something errors out it will email me and continue with the other containers.
My question is do the child tasks inside the sequence containers need the MaxErrorCount property to be a number greater than 1?
Will this not cause the error to be ignored and not send the email if the Parent Sequence Container MaxErrorCount = 10 and only 1 error in a dataflow inside has occured?
Does setting the MaxErrorCount of the SequenceContainer = 10 going to require 10 errors before it will fail and proceed to the email task it has its onfail path pointing to?
October 3, 2010 at 10:31 pm
Nice question I'll have my try...
Set MaxErrorCount = 10 for Sequence Containers
For the implement the Email Task as failure event handlers for each Sequence container in the design.
The Sequence container will fail if the errors encountered will exceed more than 10.
In the event the package encounters a single or more error the flow will be redirected to the default task event handlers.
Raunak J
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply