MaximumErrorCount

HI All,

I've created a main package the performs certain task and executes Execute package task. The package succeded on the Dev't studio when I test it, but failed on the SQL Agent.

I checked the logging of the Package that was called by the main package and I found no error/warning.

I didn't find any error on the logging of the main package but a warning was provided. Below is the warning message:

EventClass: Description: Warning The Execution method succeeded, but the number of errors raised (3) 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.

Any insight will be greatly appreciated.
Thanks,
LarryThere is a control flow item level setting (in the Properties window) called MaximumErrorCount that defaults to 1. You could probably increase this property value to 4 or 5 (as the number of errors in your case is 3). This change in setting would help you view the actual errors encountered in your package execution.