Tuesday, 15 May 2012

Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (5) 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.

Hi,
I had got the above error message suddenly after running a series of ForEach loop in SSIS.
To resolve this issue:

Check if your ForEach loop is referring to the same file location as your Excel Connection Manager is doing
Later simply set 'Delay Validation' = True

Issue is resolved.....!!

No comments:

Post a Comment