title: Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)"
body: <p>I try to load my database with tons of data from a .csv file sized 1.4 GB. But when I try to run my code I get errors. </p>
  
  <p>Here's my code:</p>
  
  <pre><code>USE [Intradata NYSE] 
  GO
  CREATE TABLE CSVTest1
  (Ticker varchar(10) NULL,
  dateval date NULL,
  timevale time(0) NULL,
  Openval varchar(10) NULL,
  Highval varchar(10) NULL,
  Lowval varchar(10) NULL,
  Closeval varchar(10) NULL,
  Volume varchar(10) NULL
  )
  GO
  
  BULK
  INSERT CSVTest1
  FROM 'c:\intramerge.csv'
  WITH
  (
  FIELDTERMINATOR = ',',
  ROWTERMINATOR = '\n'
  )
  GO
  --Check the content of the table.
  SELECT *
  FROM CSVTest1
  GO
  --Drop the table to clean up database.
  DROP TABLE CSVTest1
  GO
  </code></pre>
  
  <p>I try to build a database with lots of stockquotes. But I get this error message:</p>
  
  <blockquote>
    <p>Msg 4832, Level 16, State 1, Line 2 Bulk load: An unexpected end of
    file was encountered in the data file. Msg 7399, Level 16, State 1,
    Line 2 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 2 Cannot fetch a row from
    OLE DB provider "BULK" for linked server "(null)"</p>
  </blockquote>
  
  <p>I do not understand much of SQL, but I hope to catch a thing or two. Hope someone see what might be very obvious.</p>