Chapter 8: Understanding the Transfer Process

Error reporting for transfer processing

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. When you include this phrase, 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 the following:

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.