title: SQL Server 2012 Bulk Insert from CSV into temp table
body: <p>As the title says, I am attempting to insert a CSV into a temporary table. I am unfortunately encountering errors. </p>
  
  <p>Here is the query:</p>
  
  <pre><code>USE DATABASE5000
  
  CREATE TABLE #tempTable1
  (
      ID INT,
      CD VARCHAR(50), 
      ESD DATETIME,
      EED DATETIME, 
      MiscDate DATETIME, 
      SQ SMALLINT
  ) 
  
  BULK INSERT #tempTable1
  FROM 'C:\Dir\Folder\BestFile.csv';
  </code></pre>
  
  <p>And here are the errors I get:</p>
  
  <blockquote>
    <p>Msg 4832, Level 16, State 1, Line 1<br>
    Bulk load: An unexpected end of file was encountered in the data file.</p>
    
    <p>Msg 7399, Level 16, State 1, Line 1<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 1<br>
    Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".</p>
  </blockquote>
  
  <p>Any ideas? Thanks yall.</p>