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.
Copyright © 2005. Sybase Inc. All rights reserved. |