Problem

When executing an SSIS package, the following error appears:

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

 

Solution

If the error messages are not a concern and you want to get rid of them, open the Properties window and, under Execution section, you will see the MaximumErrorCount property. You can change it?s value from 1 (the default) to whatever you want.

The Properties window should already be open in the bottom right of BIDS (Business Intelligence Development Studio). If you don?t see it, you can open it from the menu by going to View/Properties Window, or just hit the F4 key.

 

...

 

Also, be aware that this parameter can be changed for every task or globally at the Package level. If the modification is done only at the task level and on the Package level the value remains 1 you will still get the errors. To change it for different tasks you have to click on the specific task and the values in Properties window will change. To change it at Package level you have to click somewhere on the space between tasks an the Properties window will display package lever properties. 

 

 


1 comment

Comment from: phani [Visitor] Email
phaniWhen debbuing script task I am getting an error as the script returned a failure result how I have to solve it
12/18/14 @ 00:05

This post has 86 feedbacks awaiting moderation...

Leave a comment


Your email address will not be revealed on this site.
(Line breaks become <br />)
(For my next comment on this site)
(Allow users to contact me through a message form -- Your email will not be revealed!)