title: SQL Server 2005 - Bulk Insert Problems
body: <p>I am getting the following error message from a bulk load in sql server 2005, and was after ideas I can try to solve this problem.</p>
  
  <p>Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 2, column 4 (type).</p>
  
  <pre><code>BULK INSERT dbo.BobTable FROM 'C:\DataFiles\Bob.txt' 
  WITH (FIELDTERMINATOR = '","', FIRSTROW=2,ROWTERMINATOR = '\n',DATAFILETYPE='char')
  </code></pre>
  
  <p>Any ideas? </p>
  
  <pre><code>"id","altid","altid2","type"    
  123456789.00,"ABC1234","ABC1234","R"
  </code></pre>
  
  <p>I cannot change the source file, but I can change the table that it is being inserted into.
  (Don't ask me why, but the decimals have been inserted at the end of an ID...I just have to deal with it.)</p>
  
  <pre><code>CREATE TABLE [dbo].[BOB](
    [id] [nvarchar](50) NULL,
    [Altid] [nvarchar](50) NULL,
    [Altid2] [nvarchar](50) NULL,
    [type] [nvarchar](50) NULL
  )
  </code></pre>