title: SQL Bulk Insert with FIRSTROW parameter skips the following line
body: <p>I can't seem to figure out how this is happening. </p>
  
  <p>Here's an example of the file that I'm attempting to bulk insert into SQL server 2005:</p>
  
  <pre><code>***A NICE HEADER HERE***
  0000001234|SSNV|00013893-03JUN09
  0000005678|ABCD|00013893-03JUN09
  0000009112|0000|00013893-03JUN09
  0000009112|0000|00013893-03JUN09
  </code></pre>
  
  <p>Here's my bulk insert statement:</p>
  
  <pre><code>BULK INSERT sometable
  FROM 'E:\filefromabove.txt
  WITH
  (
  FIRSTROW = 2,
  FIELDTERMINATOR= '|',
  ROWTERMINATOR = '\n'
  )
  </code></pre>
  
  <p>But, for some reason the only output I can get is:</p>
  
  <pre><code>0000005678|ABCD|00013893-03JUN09
  0000009112|0000|00013893-03JUN09
  0000009112|0000|00013893-03JUN09
  </code></pre>
  
  <p>The first record always gets skipped, unless I remove the header altogether and don't use the FIRSTROW parameter. How is this possible?</p>
  
  <p>Thanks in advance!</p>