"String data, right truncation" call BCP
<p>This is the BCP command I use for inserting data in SQL server:</p>

<pre><code>bcp sfnav.dbo.Customer in "C:\Users\TSL\Desktop\TSL Data\ID_Customer_151124.csv" -F2 -c -t "^" -r "\n" -S ftpserver\sqlexpress -U abc -P xyz
</code></pre>

<p>When I try to run the same command in a batch file it results in an error:</p>

<pre><code>call bcp sfnav.dbo.Customer in "C:\Users\TSL\Desktop\TSL Data\ID_Customer_151124.csv" -F2 -c -t "^" -r "\n" -S ftpserver\sqlexpress -U abc -P xyz
</code></pre>

<p>Error:</p>

<blockquote>
  <p>Starting copy... SQLState = 22001, NativeError = 0 Error =
  [Microsoft][ODBC Driver 11 for SQL Server]String data, right
  truncation SQLState = 22001, NativeError = 0</p>
</blockquote>