You can obtain bulk copy transfer error information in the following ways:
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.