You can use one of three methods to obtain error information about bulk copy and destination-template transfer processing:
Include the with report phrase in the transfer statement. As a result, the access service returns a result set containing one VARCHAR column and one row that indicates the number of rows transferred, rejected, and modified during processing.
Immediately following a transfer process, execute these statements:
select @@RejectedRowCount
select @@DefaultedRowCount
These global variables return the number of rejected or defaulted rows.
Set SendWarningMessages to yes, so that the access service returns warning messages to the client when data conversion errors occur.
