如何增加 SQL Server 2008 作业或包中的 MaximumErrorCount？
我有几份工作和几个包裹。在 SQL Server 2005 中，我们曾经使用 DTS 包，但它们现在已失效（我知道我可以重新启用它们，但这不是我想要的）。我在运行我的其中一个软件包时收到以下错误：
消息：SSIS 警告代码 DTS_W_MAXIMUMERRORCOUNTREACHED。这 执行方法成功了，但是 出现的错误数量达到 (1) 允许的最大值 (1)；导致 失败。当数字 错误数达到指定数量 在最大错误计数中。改变 MaximumErrorCount 或修复错误。
显然，这是先前错误的结果。我无法修复该错误，因此我想增加 MaximumErrorCount。但是，尽管互联网上有很多帖子解释说您应该选择包（或作业？）上的“属性”，但该包不再具有“属性”（我在“集成”下找到它们）服务列在DTS 包下，这很奇怪，考虑到向导创建了包并且 2008 年不支持 DTS？），我不知道如何查看包，真的。该作业确实有属性，但没有设置最大错误计数。
有人可以成为我的眼睛，看到我看不到的东西吗？在哪里根据错误消息的要求增加 MaximumErrorCount？
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. 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.
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?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
如果我在 BIDS（“Business Intelligence Development Studio”，用于设计包的工具）中打开一个包，并且不选择其中的任何项目，则右下角会出现一个“属性”窗格，其中包含 - 、
MaximumErrorCount属性。如果您没有看到它，可能它已最小化，您必须打开它（查看右侧的选项卡）。如果您无法通过这种方式找到它，请尝试菜单：查看/属性窗口。
或者尝试按 F4 键。
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
MaximumErrorCountproperty. 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.
需要强调的是，需要更改的属性 (MaximumErrorCount) 必须在包级别设置为大于 0（这是默认值），而不是在显示错误的特定控件中设置（我尝试了这个，它不起作用！）
确保在属性窗口中，下拉菜单设置为“Package”，然后查找属性 MaximumErrorCount 进行更改。
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.