SQL Server Performance Forum – Threads Archive
bcp error fileHi 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.