To obtain destination-template transfer error information, use one of these options:
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.
You can 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 will allow before it stops processing.
You can set this value with this statement:
set TransferErrorCount nnn
The default setting is 0, which causes the access service to ignore errors.
