November 2, 2009 at 5:40 pm
I got an SSIS package that has 3 execute package task and 2 execute sql task. Something that looks like the following;
Package A Package B Package C
\ /\ /
\ / \ /
SQL Task 1 Sql Task 2
Within every package every task and data flow I have the maximumerrorcount is set to 0. We have a c# wizard which calls our SSIS packages and this one package when executed returns a failure which halts the whole process. However, if I run the package within VS IDE everything runs fine and all boxes are green. Yet I get the following message in the progress tab;
Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
How can this when everything is set to 0 as maximumerrorcount?
Joe
November 2, 2009 at 7:25 pm
I assume that your question is about getting 2 errors.
If I understand your package, it looks like the 3 "Execute Package" tasks will start running in parallel. Not sure what precendence constraints apply to the "Execute SQL Tasks". However, it is possible for 2 of the "Execute Package" tasks to fail.
November 2, 2009 at 8:26 pm
Correct. These 3 run in parallel. And all of these tasks have maximumerrorcount set to 0. When I run it from VS IDE everything run's fine. I get green for every task and my data is moved from the source database to target database. Yet I get that message. I go to each progress tab for each task and none have any errors listed. Only this package has tis message at it's end.
I thought if my maximumerrorcount is set to 0 it should work.
November 3, 2009 at 12:34 am
Have you checked the Forced Execution Result (or similar - haven't got SSIS open right now)?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply