Originally posted by: nosepicker
Instead of using the -e parameter, try just redirecting the output to a file, like:
bcp database..tablename in c:\yourfile.txt -c -Uuserid -Ppassword -Sservername > c:\yourerrorfile.txt
Sometimes I get so caught up in the problem I overlook the easy solution... Your response worked a treat, and I can interrogate the new output file and determine if there was an error based upon its contents. So thanks for your assistance.
What I SHOULD do is to check if the destination table exists BEFORE performing the BCP command
That would make a lot of sense wouldn't it.