SSIS MaximumErrorCount Property
I am using a Lookup transformation to return Region information from a
reference table for a number of European customer cities. Some of the cities
do not have regions and the Lookup transform fails when it does not find a
match. I can configure Error output and ignore the errors or redirect the
rows that fail to a different destination. However, this is not what I want
to do. I would like to keep the error condition, but have it be reflected as
an error at task level where I can configure the MaximumErrorCount property
to a high number so that the task continues, in spite of the errors.
So, I set up the MaximumErrorCount property on the data flow task to 999,
but the task still fails even when there is only one lookup failure. Why? I
didn't expect this. Am I missing something?
Charles Kangai, MCT, MCDBA