title: Bulk Insert failing in SQL Server "Column is too long"
body: <p>I am trying to run the following command in SQL Server and its not working:</p>
  
  <pre><code>bulk insert dbo.Sales
  from 'C:\Users\sram1\Downloads\SalesFile20161103\SALECOPY.TXT'
  with 
  (
      FIRSTROW = 1,
      FIELDTERMINATOR = '\t',
      ROWTERMINATOR = '0x0a'
  )
  </code></pre>
  
  <p>Here is the error message that is printed:</p>
  
  <blockquote>
    <p>Msg 4866, Level 16, State 1, Line 131<br>
    The bulk load failed. The column is too long in the data file for row 1, column 1. Verify that the field terminator and row terminator are specified correctly.  </p>
    
    <p>Msg 7399, Level 16, State 1, Line 131<br>
    The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.</p>
    
    <p>Msg 7330, Level 16, State 2, Line 131<br>
    Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".</p>
  </blockquote>
  
  <p>I looked throughout StackOverflow, and saw that I should change the rowterminator, and I have tried both '0x0a' and '\r\n'. My data is tab separated, but it appears that in some cases, the tab is 2 spaces, other times it is more, other times it is less. Is this perhaps the root of the problem? If so, how do I fix it?</p>