DTS error allow

#1

Is there a number of DTS error allowed before completing the execution? I saw
it somewhere but couldn't rember where.

Thanks a lot.

#2

Hello Matthew,

You can find this option in the properties for a Transform Data Task, under
the Options tab and it's called Max error count. By default, this setting is
0 meaning that the task will fail at the first row or batch error.

Good luck!
Pavel
http://www.reporting.ro/

"Matthew Z" wrote:

Quote:

Is there a number of DTS error allowed before completing the execution? I saw
it somewhere but couldn't rember where.

Thanks a lot.

#3

Thanks Pavel, it helped me a lot. Do you know the what is max number it can
go? I thought is 10, but it looked like it can be any number we set there.

"Pavel" wrote:

Quote:

Hello Matthew,

You can find this option in the properties for a Transform Data Task, under
the Options tab and it's called Max error count. By default, this setting is
0 meaning that the task will fail at the first row or batch error.

Good luck!
Pavel
http://www.reporting.ro/

"Matthew Z" wrote:

Is there a number of DTS error allowed before completing the execution? I saw
it somewhere but couldn't rember where.

Thanks a lot.

#4

The UI will only let you enter 9999 but the datatype is a long so you
can set it to more than 9999 in code

Allan

"Matthew Z" <MatthewZ (AT) discussions (DOT) microsoft.com> wrote

Quote:

Thanks Pavel, it helped me a lot. Do you know the what is max number it
can
go? I thought is 10, but it looked like it can be any number we set
there.

"Pavel" wrote:

Hello Matthew,

You can find this option in the properties for a Transform Data Task,
under
the Options tab and it's called Max error count. By default, this
setting is
0 meaning that the task will fail at the first row or batch error.

Good luck!
Pavel
http://www.reporting.ro/

"Matthew Z" wrote:

Is there a number of DTS error allowed before completing the
execution? I saw
it somewhere but couldn't rember where.

Thanks a lot.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS error allow

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS error allow - 11-09-2005 , 06:38 PM

RE: DTS error allow - 11-10-2005 , 12:23 AM

RE: DTS error allow - 11-10-2005 , 08:49 AM

RE: DTS error allow - 11-10-2005 , 02:25 PM