Geek Answers Handbook

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

I have several tasks and several packages. In SQL Server 2005, we used DTS Packages, but now they do not work (I know that I can reactivate them, but this is not what I need). I get 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 allowable (1); causing failure. This occurs when the number of errors reaches the specified number in MaximumErrorCount. Change MaximumErrorCount or fix errors.

Obviously, this is the result of an earlier error. I cannot fix this error, so I want to increase MaximumErrorCount . But although there are many posts on the Internet explaining that you should select “Properties” on the package (or job?), The Package no longer has properties (I found them in the Integration Services section, where they are listed in DTS packages that are odd , given that the wizard created the package, and DTS is not supported in 2008?), I don’t know how to look in the package, really. And the work has properties, but the parameter Maximum number of errors does not exist anywhere.

Can someone look at me and see what I do not see? Where to increase the MaximumErrorCount value according to the error request?

+7
sql-server-2008 sql-server-job ssis
source share
2 answers

If I open a package in BIDS ("Business Intelligence Development Studio", the tool that you use to create packages) and don’t select any item in it, I have a Properties panel at the bottom right, containing, among others, a property MaximumErrorCount . If you don’t see it, it may be minimized and you need to open it (look at the tabs on the right).

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

Or try the F4 key.

+18
source share

It is important to emphasize that the (MaximumErrorCount) property that needs to be changed must be set to more than 0 (which is the default) at the package level, and not in the specific control that shows the error (I tried this and it does not work!)

Verify that the Properties window of the Pull menu is set to Batch, then find the MaximumErrorCount property to change it.

+4
source share

More articles:


All Articles