MaximumErrorCount Problem with Copy Database Wizard

I am getting the MaximumErrorCount error when running the Copy Database Wizard. There is an error that I recognize with a stored procedure. I am not interested necessarily in fixing the stored proc error. Rather, I want to just simply copy it "as is" (working in production by the way) and then modify it locally.

I am trying to copy a production database to a develoment environment in order to test against some data. I keep getting the following error:

"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."

How do I configure the MaximumErrorCount on a particular Copy Database process?

I have looked through the documentation, and have not found any place in the UI to make this change.

I am copying a SQL 2000 db to a SQL 2005 (SP1) instance running on Windows XP SP2.

It makes no sense that I cannot make a configuration as recommended by the error message.

Thanks.

Dennis

I don't think the wizard UI makes this property available. However, if you save the package and open it in BIDS, you can change it there.

MaximumErrorCount

HI All,

I've created a main package the performs certain task and executes Execute package task. The package succeded on the Dev't studio when I test it, but failed on the SQL Agent.

I checked the logging of the Package that was called by the main package and I found no error/warning.

I didn't find any error on the logging of the main package but a warning was provided. Below is the warning message:

EventClass: Description: Warning The Execution method succeeded, but the number of errors raised (3) 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.

Any insight will be greatly appreciated.
Thanks,
LarryThere is a control flow item level setting (in the Properties window) called MaximumErrorCount that defaults to 1. You could probably increase this property value to 4 or 5 (as the number of errors in your case is 3). This change in setting would help you view the actual errors encountered in your package execution.

MaximumErrorCount

Trying to find MaximumErrorCount. May anyone explain me, what is it and
where is it? What program should be invoked, what menu commands used? I can
find a task in SQL Agent, but I have no idea how to force it ignore
nonexistent errors.
Yours faithfully, Vadim Maksimenko.
Hi Vadim Maksimenko
I assume this is a data pump task in a DTS package? In which case check out
information on error handling in
http://msdn2.microsoft.com/en-us/library/aa933500(SQL.80).aspx
John
"Vadim Maksimenko" wrote:

> Trying to find MaximumErrorCount. May anyone explain me, what is it and
> where is it? What program should be invoked, what menu commands used? I can
> find a task in SQL Agent, but I have no idea how to force it ignore
> nonexistent errors.
> --
> Yours faithfully, Vadim Maksimenko.
>
|||Thank you so much, but my problem is an attempt to use stupid Database Copy
Wizard from SQL Server 2005. It creates a task with is neither available for
editing nor accessible through Properties. Stupid, because it attempts to
copy views' contents!!! Could ignore that via setting MaximumErrorCount to
billions, but cannot locate that parameter.
Yours faithfully, Vadim Maksimenko.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:EAF5893E-1A0A-45D1-B35B-BCE41BEDE711@.microsoft.com...[vbcol=seagreen]
> Hi Vadim Maksimenko
> I assume this is a data pump task in a DTS package? In which case check
> out
> information on error handling in
> http://msdn2.microsoft.com/en-us/library/aa933500(SQL.80).aspx
> John
> "Vadim Maksimenko" wrote:
|||Hi Vadim Maksimenko
You can use the wizard to create a SSIS package which you can then change in
BIDS. Having the export as a package will also allow it to be run in a ad-hoc
manner using dtexec and give you the option to specify verbose logging.
John
"Vadim Maksimenko" wrote:

> Thank you so much, but my problem is an attempt to use stupid Database Copy
> Wizard from SQL Server 2005. It creates a task with is neither available for
> editing nor accessible through Properties. Stupid, because it attempts to
> copy views' contents!!! Could ignore that via setting MaximumErrorCount to
> billions, but cannot locate that parameter.
> --
> Yours faithfully, Vadim Maksimenko.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:EAF5893E-1A0A-45D1-B35B-BCE41BEDE711@.microsoft.com...
>
|||Already have found a better solution: MS SQL Maestro -- waaay much more
comfortable than original MS manager It does not force to look for brains
in the XXX in order to edit an SQL Agent job.
Yours faithfully, Vadim Maksimenko.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:97F23B99-5505-42B1-B17F-C534E0BBD15A@.microsoft.com...[vbcol=seagreen]
> Hi Vadim Maksimenko
> You can use the wizard to create a SSIS package which you can then change
> in
> BIDS. Having the export as a package will also allow it to be run in a
> ad-hoc
> manner using dtexec and give you the option to specify verbose logging.
> John
> "Vadim Maksimenko" wrote:
|||rHi
If SQL Maestro does it for you that's fine, but as I said it's nothing to do
with SQL Agent, so I am not surprised you couldn't find it.
John
"Vadim Maksimenko" wrote:

> Already have found a better solution: MS SQL Maestro -- waaay much more
> comfortable than original MS manager It does not force to look for brains
> in the XXX in order to edit an SQL Agent job.
> --
> Yours faithfully, Vadim Maksimenko.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:97F23B99-5505-42B1-B17F-C534E0BBD15A@.microsoft.com...
>
sql

MaximumErrorCount

Trying to find MaximumErrorCount. May anyone explain me, what is it and
where is it? What program should be invoked, what menu commands used? I can
find a task in SQL Agent, but I have no idea how to force it ignore
nonexistent errors.
--
Yours faithfully, Vadim Maksimenko.Hi Vadim Maksimenko
I assume this is a data pump task in a DTS package? In which case check out
information on error handling in
http://msdn2.microsoft.com/en-us/library/aa933500(SQL.80).aspx
John
"Vadim Maksimenko" wrote:
> Trying to find MaximumErrorCount. May anyone explain me, what is it and
> where is it? What program should be invoked, what menu commands used? I can
> find a task in SQL Agent, but I have no idea how to force it ignore
> nonexistent errors.
> --
> Yours faithfully, Vadim Maksimenko.
>|||Thank you so much, but my problem is an attempt to use stupid Database Copy
Wizard from SQL Server 2005. It creates a task with is neither available for
editing nor accessible through Properties. Stupid, because it attempts to
copy views' contents!!! Could ignore that via setting MaximumErrorCount to
billions, but cannot locate that parameter.
--
Yours faithfully, Vadim Maksimenko.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:EAF5893E-1A0A-45D1-B35B-BCE41BEDE711@.microsoft.com...
> Hi Vadim Maksimenko
> I assume this is a data pump task in a DTS package? In which case check
> out
> information on error handling in
> http://msdn2.microsoft.com/en-us/library/aa933500(SQL.80).aspx
> John
> "Vadim Maksimenko" wrote:
>> Trying to find MaximumErrorCount. May anyone explain me, what is it and
>> where is it? What program should be invoked, what menu commands used? I
>> can
>> find a task in SQL Agent, but I have no idea how to force it ignore
>> nonexistent errors.
>> --
>> Yours faithfully, Vadim Maksimenko.
>>|||Hi Vadim Maksimenko
You can use the wizard to create a SSIS package which you can then change in
BIDS. Having the export as a package will also allow it to be run in a ad-hoc
manner using dtexec and give you the option to specify verbose logging.
John
"Vadim Maksimenko" wrote:
> Thank you so much, but my problem is an attempt to use stupid Database Copy
> Wizard from SQL Server 2005. It creates a task with is neither available for
> editing nor accessible through Properties. Stupid, because it attempts to
> copy views' contents!!! Could ignore that via setting MaximumErrorCount to
> billions, but cannot locate that parameter.
> --
> Yours faithfully, Vadim Maksimenko.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:EAF5893E-1A0A-45D1-B35B-BCE41BEDE711@.microsoft.com...
> > Hi Vadim Maksimenko
> >
> > I assume this is a data pump task in a DTS package? In which case check
> > out
> > information on error handling in
> > http://msdn2.microsoft.com/en-us/library/aa933500(SQL.80).aspx
> >
> > John
> >
> > "Vadim Maksimenko" wrote:
> >
> >> Trying to find MaximumErrorCount. May anyone explain me, what is it and
> >> where is it? What program should be invoked, what menu commands used? I
> >> can
> >> find a task in SQL Agent, but I have no idea how to force it ignore
> >> nonexistent errors.
> >>
> >> --
> >>
> >> Yours faithfully, Vadim Maksimenko.
> >>
> >>
>|||Already have found a better solution: MS SQL Maestro -- waaay much more
comfortable than original MS manager :) It does not force to look for brains
in the ass in order to edit an SQL Agent job.
--
Yours faithfully, Vadim Maksimenko.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:97F23B99-5505-42B1-B17F-C534E0BBD15A@.microsoft.com...
> Hi Vadim Maksimenko
> You can use the wizard to create a SSIS package which you can then change
> in
> BIDS. Having the export as a package will also allow it to be run in a
> ad-hoc
> manner using dtexec and give you the option to specify verbose logging.
> John
> "Vadim Maksimenko" wrote:
>> Thank you so much, but my problem is an attempt to use stupid Database
>> Copy
>> Wizard from SQL Server 2005. It creates a task with is neither available
>> for
>> editing nor accessible through Properties. Stupid, because it attempts to
>> copy views' contents!!! Could ignore that via setting MaximumErrorCount
>> to
>> billions, but cannot locate that parameter.
>> --
>> Yours faithfully, Vadim Maksimenko.
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:EAF5893E-1A0A-45D1-B35B-BCE41BEDE711@.microsoft.com...
>> > Hi Vadim Maksimenko
>> >
>> > I assume this is a data pump task in a DTS package? In which case check
>> > out
>> > information on error handling in
>> > http://msdn2.microsoft.com/en-us/library/aa933500(SQL.80).aspx
>> >
>> > John
>> >
>> > "Vadim Maksimenko" wrote:
>> >
>> >> Trying to find MaximumErrorCount. May anyone explain me, what is it
>> >> and
>> >> where is it? What program should be invoked, what menu commands used?
>> >> I
>> >> can
>> >> find a task in SQL Agent, but I have no idea how to force it ignore
>> >> nonexistent errors.
>> >>
>> >> --
>> >>
>> >> Yours faithfully, Vadim Maksimenko.
>> >>
>> >>
>>|||rHi
If SQL Maestro does it for you that's fine, but as I said it's nothing to do
with SQL Agent, so I am not surprised you couldn't find it.
John
"Vadim Maksimenko" wrote:
> Already have found a better solution: MS SQL Maestro -- waaay much more
> comfortable than original MS manager :) It does not force to look for brains
> in the ass in order to edit an SQL Agent job.
> --
> Yours faithfully, Vadim Maksimenko.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:97F23B99-5505-42B1-B17F-C534E0BBD15A@.microsoft.com...
> > Hi Vadim Maksimenko
> >
> > You can use the wizard to create a SSIS package which you can then change
> > in
> > BIDS. Having the export as a package will also allow it to be run in a
> > ad-hoc
> > manner using dtexec and give you the option to specify verbose logging.
> >
> > John
> >
> > "Vadim Maksimenko" wrote:
> >
> >> Thank you so much, but my problem is an attempt to use stupid Database
> >> Copy
> >> Wizard from SQL Server 2005. It creates a task with is neither available
> >> for
> >> editing nor accessible through Properties. Stupid, because it attempts to
> >> copy views' contents!!! Could ignore that via setting MaximumErrorCount
> >> to
> >> billions, but cannot locate that parameter.
> >>
> >> --
> >>
> >> Yours faithfully, Vadim Maksimenko.
> >>
> >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> news:EAF5893E-1A0A-45D1-B35B-BCE41BEDE711@.microsoft.com...
> >> > Hi Vadim Maksimenko
> >> >
> >> > I assume this is a data pump task in a DTS package? In which case check
> >> > out
> >> > information on error handling in
> >> > http://msdn2.microsoft.com/en-us/library/aa933500(SQL.80).aspx
> >> >
> >> > John
> >> >
> >> > "Vadim Maksimenko" wrote:
> >> >
> >> >> Trying to find MaximumErrorCount. May anyone explain me, what is it
> >> >> and
> >> >> where is it? What program should be invoked, what menu commands used?
> >> >> I
> >> >> can
> >> >> find a task in SQL Agent, but I have no idea how to force it ignore
> >> >> nonexistent errors.
> >> >>
> >> >> --
> >> >>
> >> >> Yours faithfully, Vadim Maksimenko.
> >> >>
> >> >>
> >>
> >>
>