title: Bulk Insert not working in SQL Server 2008
body: <p>Here's my SQL to bulk load a CSV file into SQL Server 2008, but its returning:</p>
  
  <pre><code>0 row(s) affected.
  </code></pre>
  
  <p>Code:</p>
  
  <pre><code>USE energyDB
  GO
  
  BULK INSERT energydata
  FROM 'c:\temp\24544_MSSQL_out.csv'
  WITH
  (
    FIRSTROW = 2,
    FIELDTERMINATOR = ',',
    ROWTERMINATOR = '\n'
  )
  GO
  </code></pre>
  
  <p>The CSV file looks like this (the top line is ignored)</p>
  
  <pre><code>24544,"1970-01-01 10:00:00","8056060 kWh"
  24544,"2012-12-04 00:15:00",0.176
  24544,"2012-12-04 00:30:00",0.163
  24544,"2012-12-04 00:45:00",0.016
  </code></pre>