title: BULK INSERT 4866 and 7301
body: <p>Trying to BULK import data in SQL server with below lines but getting error:</p>
  
  <blockquote>
    <p>Msg 4866, Level 16, State 8, Line 3<br>
    The bulk load failed. The column is too long in the data file for row 1, column 96. Verify that the field terminator and row terminator are specified correctly. </p>
    
    <p>Msg 7301, Level 16, State 2, Line 3<br>
    Cannot obtain the required interface ("IID_IColumnsInfo") from OLE DB provider "BULK" for linked server "(null)".</p>
  </blockquote>
  
  <p>Is there anything wrong with my statements? As when I use import wizard it works fine.</p>
  
  <pre><code>BULK INSERT BICX.dbo.raw
  FROM 'D:\NEW_CDR\NEW.txt'
  WITH
  (
     FIRSTROW = 5,
     FIELDTERMINATOR = ',',
     ROWTERMINATOR = '\n'
  );
  </code></pre>