title: BULK INSERT error with unknown cause
body: <p>I am trying to BULK insert a rather wide (220 column) dataset into a SQL Server 2016 table using the following:</p>
  
  <pre><code>BULK INSERT dbo.[table] 
  FROM 'C:\source.txt'
  WITH
  (
      FIELDTERMINATOR = ',',
      ROWTERMINATOR = '0x0A'
  );
  </code></pre>
  
  <p>From the start I had a couple of issues with the row terminator, but everything seemed to be working fine when I fixed it to be 'OX0A' instead of '\n' until I tried processing a rather large file (in relation to other I am loading). To give you an idea, it contains about 220 columns (destination being NVARCHAR(255), source is pretty much INT) and 10 000 rows. File file size is no larger than 40mb.</p>
  
  <p>Here is the error I am getting:</p>
  
  <pre><code>Msg 7399, Level 16, State 1, Line 6
  The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
  Msg 7330, Level 16, State 2, Line 6
  Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".
  </code></pre>
  
  <p>Some more info: </p>
  
  <ul>
  <li><p>I get the same error if I use FIRSTROW AND LASTROW.</p></li>
  <li><p>When trying to find the offending row, the file started working once I started removing rows (started working when I had about 1910 rows in my set).</p></li>
  <li><p>It it doesn't matter from where I remove the rows, If I keep the top 1910 rows or the bottom 1910 rows it works, but as soon as I add more rows (which are valid) it breaks again.</p></li>
  <li><p>I am about 99% sure there is nothing wrong with my row endings or other formatting issues.</p></li>
  <li><p>Errorfile is emptry even after the failure.</p></li>
  </ul>
  
  <p>My gut feeling is that it has something to do with memory management, but as far as I know my memory is maxed out and the files themselves are rather small and should not be giving me memory issues.</p>
  
  <p>Any advice?</p>