title: Bulk Insert doesn't insert any rows
body: <p>I am importing data from CSV files into temp tables before merging them with a "real" table.</p>
  
  <p>For my other tables, this works fine. But for this one particular file and table, nothing seems to happen.</p>
  
  <pre><code>CREATE TABLE #ManifestHeader (  
  [ROTATIONNUMBER] [nvarchar](12) NOT NULL,
  [ROTATIONVERSIONNO] [nvarchar](2) NOT NULL,
  [IMONUM] [nvarchar](50) NULL,
  [VESSELNAME] [nvarchar](35) NOT NULL,
  [VOYAGENO] [nvarchar](17) NOT NULL,
  [CARRIERCODE] [nvarchar](10) NULL,
  [CARRIERNAME] [nvarchar](35) NULL,
  [ETA] [datetime] NULL,
  [ETD] [datetime] NULL,
  [ACTUALARRIVALDATE] [datetime] NULL,
  [LASTPORTOFCALL] [nvarchar](5) NULL,
  [PORTARRIVAL] [nvarchar](5) NULL,
  [PORTNEXT] [nvarchar](5) NULL,
  [PORTFINAL] [nvarchar](5) NULL,    
  [BERTHINGDATE] [datetime] NULL,
  [CDRSTARTDATE] [datetime] NULL,
  [CDRENDDATE] [datetime] NULL,
  [CDRSUBMISSIONDATE] [datetime] NULL,
  [NUMOFBOLS] [int] NULL,
  )
  
  BULK INSERT #ManifestHeader
  FROM 'D:\csvfiles\ManifestHeader.csv'
  WITH ( FIELDTERMINATOR = '&lt;,&gt;', ROWTERMINATOR = '\n', FIRSTROW = 2, KEEPIDENTITY );
  
  SELECT * FROM #ManifestHeader;
  </code></pre>
  
  <p>The last select statement returns nothing and no errors are shown.</p>
  
  <p>The CSV file contains thousands of lines. Example lines:</p>
  
  <pre><code>ROTATIONNUMBER&lt;,&gt;ROTATIONVERSIONNO&lt;,&gt;IMONUM&lt;,&gt;VESSELNAME&lt;,&gt;VOYAGENO&lt;,&gt;CARRIERCODE&lt;,&gt;CARRIERNAME&lt;,&gt;ETA&lt;,&gt;ETD&lt;,&gt;ACTUALARRIVALDATE&lt;,&gt;LASTPORTOFCALL&lt;,&gt;PORTARRIVAL&lt;,&gt;PORTNEXT&lt;,&gt;PORTFINAL&lt;,&gt;BERTHINGDATE&lt;,&gt;CDRSTARTDATE&lt;,&gt;CDRENDDATE&lt;,&gt;CDRSUBMISSIONDATE&lt;,&gt;NUMOFBOLS
  12345678911&lt;,&gt;1&lt;,&gt;VB3BV&lt;,&gt;BLACKSTONE&lt;,&gt;020&lt;,&gt;MUNICA&lt;,&gt;MUNICA&lt;,&gt;2012-05-08 10:32:00&lt;,&gt;2012-05-08 11:32:00&lt;,&gt;2012-05-09 07:15:00&lt;,&gt;SGSIN&lt;,&gt;MZZPZ&lt;,&gt;MZZBW&lt;,&gt;MZZBW&lt;,&gt;&lt;,&gt;2012-05-09 07:22:00&lt;,&gt;&lt;,&gt;2012-05-09 07:22:26&lt;,&gt;1
  12345678912&lt;,&gt;1&lt;,&gt;VB4BV&lt;,&gt;REDSTONE&lt;,&gt;021&lt;,&gt;MUNICA&lt;,&gt;MUNICA&lt;,&gt;2011-11-29 11:48:00&lt;,&gt;2011-11-30 11:48:00&lt;,&gt;&lt;,&gt;ZADER&lt;,&gt;MZZPZ&lt;,&gt;ZARCB&lt;,&gt;MZZPZ&lt;,&gt;&lt;,&gt;&lt;,&gt;&lt;,&gt;&lt;,&gt;
  12345678913&lt;,&gt;1&lt;,&gt;VB5BV&lt;,&gt;BLUESTONE&lt;,&gt;022&lt;,&gt;MUNICA&lt;,&gt;MUNICA&lt;,&gt;2012-05-09 08:00:00&lt;,&gt;2012-05-10 10:39:00&lt;,&gt;2012-05-09 11:11:00&lt;,&gt;ZADER&lt;,&gt;MZZPZ&lt;,&gt;ZARCB&lt;,&gt;ITCVV&lt;,&gt;&lt;,&gt;2012-05-09 15:00:00&lt;,&gt;&lt;,&gt;2012-05-07 11:14:42&lt;,&gt;1
  12345678914&lt;,&gt;1&lt;,&gt;VB6BV&lt;,&gt;GREENSTONE&lt;,&gt;023&lt;,&gt;MUNICA&lt;,&gt;MUNICA&lt;,&gt;2012-05-29 07:00:00&lt;,&gt;2012-05-29 23:00:00&lt;,&gt;2012-05-29 09:12:00&lt;,&gt;LKCMB&lt;,&gt;MZMNC&lt;,&gt;MZMNC&lt;,&gt;SGSIN&lt;,&gt;&lt;,&gt;2012-05-29 23:00:00&lt;,&gt;2012-05-30 12:00:00&lt;,&gt;2012-05-29 09:30:33&lt;,&gt;1
  </code></pre>
  
  <p>What could I be missing here?</p>