You can obtain bulk copy transfer error information by:
Including the with report phrase 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.
Executing @@RejectedRowCount or @@DefaultedRowCount immediately after a successful transfer. These global variables return the number of rejected or defaulted rows.
Setting SendWarningMessages to yes, so the access service returns data conversion errors to the client application.
