If
you include with report in the transfer
statement, you receive a result set containing one VARCHAR
column and one row indicating the number of rows transferred, rejected, and
modified during processing.
Execute @@RejectedRowCount or @@DefaultedRowCount immediately
after a successful transfer. These global variables return the number
of rejected or defaulted rows.
If you set SendWarningMessages to
yes, the access service
returns data conversion errors to the client application.
During processing, the access service
sets the StopCondition property to none. It uses the value in
the TransferErrorCount property to determine the number of
error rows it allows before it stops processing.
Set this value with this
statement:
set TransferErrorCount nnn
The default setting is
0, which causes the access service to ignore
errors.