How to troubleshoot "BCP copy in failed"
Here is how I recommend doing it, which is tailored for character data:


generate format file 
edit format file to match the input data structure
upload the data file using the format file generated at step 2


corresponding commands are then as follows:


run bcp [&lt;my_db_name&gt;].&lt;my_schema_name&gt;.&lt;my_table_name&gt; format nul -c -f
&lt;my_format_file_name&gt;.fmt -t\&lt;my_delimiter_char&gt; -S &lt;my_db_server&gt;
-U &lt;my_db_user&gt;
use any text editor if edition is needed
run bcp [&lt;my_db_name&gt;].&lt;my_schema_name&gt;.&lt;my_table_name&gt; in &lt;my_data_file&gt; -f &lt;my_format_file_name&gt;.fmt -t\&lt;my_delimiter_char&gt;  -b &lt;my_batch_size&gt; -m &lt;my_max_errors&gt; -e &lt;my_error_file&gt;  -S &lt;my_db_server&gt; -U &lt;my_db_user&gt;


Then, you can inspect &lt;my_error_file&gt; to see how it went. Execution without any error should produce empty &lt;my_error_file&gt;.