Dear All
I have a problem to export a table to .dbf file. The table contain 6 Millions records. The output file is used for foxpro (DOS version). I tried using DTS export wizard but the process failed when reached 225000. The table consist of 32 column and most of the use varchar data type with two column using datetime. The Error message is "The number of failing rows exceeds the maximum specified". Could not update; currently lock."

DTS allows you to specify a number of rows which is happy to let you FAIL
before it considers the package a failure. This is by default 0.
Are you using DTS 2000 ? If you are then you can have the DataPump task log
the failing rows to identify the problems.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Rahmadi Aji" <anonymous (AT) discussions (DOT) microsoft.com> wrote

using DTS export wizard but the process failed when reached 225000. The
table consist of 32 column and most of the use varchar data type with two
column using datetime. The Error message is "The number of failing rows
exceeds the maximum specified". Could not update; currently lock."

I already use fail condition at the option in Transform Data Task Properties (I use SQL 2000). I fill it with 100 for maximum error count, then it happen. Then I try using dummy table with 50000 records, then I use DTS, it works. Then I truncate the table and fill it with next 50000 records, it works. I think there is no problem with my data. The problem is when I try to transform all 6 millions rows to dbf file with DTS. I also have configured the buffer size and the error message log.
Thank you very much.

Rahmadi Aji

Maybe but 50,000 + 50,000 is not equal to the 225000 which you quoted as
being your breaking point.

So why not break the Export up into batches?

--

----------------------------

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


"Rahmadi Aji" <anonymous (AT) discussions (DOT) microsoft.com> wrote

then it happen. Then I try using dummy table with 50000 records, then I use
DTS, it works. Then I truncate the table and fill it with next 50000
records, it works. I think there is no problem with my data. The problem is
when I try to transform all 6 millions rows to dbf file with DTS. I also
have configured the buffer size and the error message log.