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
When working with error files generated by copy out, note that:
- 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.