title: BULK INSERT with identity (auto-increment) column
body: <p>I am trying to add bulk data in database from CSV file.</p>
  
  <p>Employee table has a column <code>ID</code> (PK) auto-incremented.</p>
  
  <pre><code>CREATE TABLE [dbo].[Employee](
   [id] [int] IDENTITY(1,1) NOT NULL,
   [Name] [varchar](50) NULL,
   [Address] [varchar](50) NULL
  ) ON [PRIMARY]
  </code></pre>
  
  <p>I am using this query:</p>
  
  <pre><code>BULK INSERT Employee  FROM 'path\tempFile.csv ' 
  WITH (FIRSTROW = 2,KEEPIDENTITY,FIELDTERMINATOR = ',' , ROWTERMINATOR = '\n');
  </code></pre>
  
  <p>.CSV File -</p>
  
  <pre><code>Name,Address
  name1,addr test 1
  name2,addr test 2
  </code></pre>
  
  <p>but it results in this error message:</p>
  
  <blockquote>
    <p>Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 2, column 1 (id).</p>
  </blockquote>