During the copy out process, as with copy in, bcp overwrites any file of the same name and does not create an error file if no errors occurred.
There are two situations that cause rows to be logged in the error file during a copy out:
A data conversion error in one of the row’s columns
An I/O error in writing to the host file
Keep the following in mind when working with error files generated by copy out:
bcp logs rows in the error file in the default character format.
All data values print as characters with tabs between the columns and a newline terminator at the end of each row.
