开发者

How to increase MaximumErrorCount in SQL Server 2008 Jobs or Packages?

开发者 https://www.devze.com 2023-01-13 16:17 出处:网络
I have several jobs and several packages. In SQL Server 2005 we used to use DTS Packages, but they are now defunct (I know that I can re-enable them, but that\'s not what I\'m after). I receive the fo

I have several jobs and several packages. In SQL Server 2005 we used to use DTS Packages, but they are now defunct (I know that I can re-enable them, but that's not what I'm after). I receive the following error by running one of my packages:

Message: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. Th开发者_Go百科e 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.

Obviously, this is a result of an earlier error. I cannot fix that error, so I want to increase the MaximumErrorCount. But even though there are numerous posts on the internet explaining that you should select Properties on the package (or the job?), the package doesn't have Properties anymore (I found them under Integration Services where they're listed under DTS Packages which is odd, considering a wizard created the package and DTS is not supported by 2008?), I've no clue how to look into the package, really. And the job does have Properties, but nowhere is there a setting Maximum error count.

Can someone be the eyes for me and see what I cannot see? Where do I increase the MaximumErrorCount as requested by the error message?


If I have open a package in BIDS ("Business Intelligence Development Studio", the tool you use to design the packages), and do not select any item in it, I have a "Properties" pane in the bottom right containing - among others, the MaximumErrorCount property. If you do not see it, maybe it is minimized and you have to open it (have a look at tabs in the right).

If you cannot find it this way, try the menu: View/Properties Window.

Or try the F4 key.


It is important to highlight that the Property (MaximumErrorCount) that needs to be changed must be set as more than 0 (which is the default) in the Package level and not in the specific control that is showing the error (I tried this and it does not work!)

Be sure that in the Properties Window, the Pull down menu is set to "Package", then look for the property MaximumErrorCount to change it.


Just to show the image: I have changed the maximum error count to 5

How to increase MaximumErrorCount in SQL Server 2008 Jobs or Packages?

0

精彩评论

暂无评论...
验证码 换一张
取 消