Copy In and Error Files

When you specify the -e error_file option with copy in, bcp stores the rows that it cannot copy in to Adaptive Server in the specified error file.

bcp in detects two types of errors:

The copy in process displays error messages on your monitor.

This example loads the newpubs file into the publishers database, storing any error rows in the pub_err file:
bcp pubs2..publishers in newpubs -epub_err
When working with error files generated by copy in, note: