title: BCP - Invalid character value for cast specification when importing to table with IDENTITY column
body: <p>I am trying to load a file from UNIX to SQL Server. When I run the BCP getting the error below, but I was able to load the same file when I changed the datatype to Char. </p>
  
  <p>Command used:</p>
  
  <p><strong>--<code>bcp  [SQLAAA].[APP_XXX].[ACTIVITY_V1]  in /home/XXX_ACTIVITY.txt -c  -S xddb001 -e /home/ERRORS.log -t "|" -r "\n"    -U test12 -P test12</code></strong></p>
  
  <p>Source file:</p>
  
  <pre class="lang-none prettyprint-override"><code>222|2017-12-27|Y|ABC|2017-12-27|ABC|2017-12-27
  255|2018-01-04|N|ABC|2018-01-04|ABC|2018-01-04
  </code></pre>
  
  <p>Error Message:</p>
  
  <blockquote>
    <p>@ Row 1, Column 7: Invalid character value for cast specification @</p>
  </blockquote>
  
  <p>Definition table:</p>
  
  <pre><code>CREATE TABLE [APP_XX].[ACTIVITY]
  (
  [C1] [varchar](10) NOT NULL,
  [C2_DATE] [date] NOT NULL,
  [c3] [varchar](1) NULL,
  [C4_NM] [varchar](10) NULL,
  [C5_DTM] [date] NULL,
  [C6_NM] [varchar](10) NULL,
  [C7_DTM] [date] NULL,
  [ROW_ID] [bigint] IDENTITY(1,1) NOT NULL
  ) ON [PRIMARY]
  </code></pre>
  
  <p>Could you please let me know what modification can be done?</p>