SQLServer-SSIS-Wrong execution status- MaximumErrorCount

I was investigating abnormal behavior of SSIS package, the package completed successfully but failed to complete actual dataflow task. MaximumErrorCount value was the culprit, its value changed from 1 to 1000!

Changing MaximumErrorCount value from 1 to X indicates SSIS Package to ignore X-1 failures and throw the error on xth failure.

MaximumErrorCount parameter can be effectively used while processing multiple files, to ignore one of the failure and continue to process other files. But we can configure an alert to trigger @Event Handler to handle one failure;

Good article about handling SSIS Errors: http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/93432/

SSIS Package completes with wrong execution status
Dataflow failures are ignored in SSIS result
How to continue SSIS Package after errors

This entry was posted in SQL, SQL Error, SSIS and tagged , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s