title: Bulk Insert Type Mismatch T-SQL
body: <p>Am using this BULK INSERT command to insert a csv file in SQL Server 2012 Express.</p>
  
  <pre><code>BULK INSERT dbo.TS_FX
     FROM 'c:\fxRates.csv'
     WITH 
     (
        FIELDTERMINATOR =',',
        ROWTERMINATOR =',\n'
     );
  </code></pre>
  
  <p>The First Row on the fxRatesCSV file looks like this:</p>
  
  <pre><code>101,20130430,20130531,1.5307
  </code></pre>
  
  <p>The error I get is:</p>
  
  <blockquote>
    <p>Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 4 (FX_RATE).</p>
  </blockquote>
  
  <p>My table (<code>dbo.TS_FX</code>) has 4 columns in it defined as follows</p>
  
  <pre><code>CURRENCY_ID (Numeric(3,0), null)
  BEGIN_DATE (date, null)
  END_DATE (date, null)
  FX_RATE (float, null)
  </code></pre>
  
  <p>Clearly the error is the way I have defined the <code>FX_RATE</code> column, I have tried various other types (<code>Decimal, Numeric</code>) but I still get the same error</p>
  
  <p>Any help is much appreciated.</p>
  
  <p>Thanks</p>