bcp error file | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

bcp error file

Hi I am using the -e argument in a bcp command to create a file of any rows that it fails to transfer. Even if there are no errors, it will create the error file but with nothing in it. Also, each time it runs, it overwrites the existing file. Is there any way to only create the error file if there are errors, or to stop it overwriting the file and append instead? Thanks in advance.
I think there is no such switch to append the log file, you may need to control that via another set of qureies like copy file a different name. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.