I have a situation where I need to allow unlimited errors and can't figure
out how to set this beyond 9999. When a row doesn't meet certain criteria I
send it to the Exception File which counts as an error. I have over 1
million rows I am trying to run through this Transform and approximately
30,000 of them need to be booted out to the exception file. Any information
on how to get around this limitation would be appreciated.

Todd

This is a limitation of the GUI. Do it in the object model at the start of
the package. MaximumErrorCount property of the DataPump task object. Takes
a long as input.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Todd Sorrell" <todd.sorrell (AT) ncwildlife (DOT) org> wrote