title: Import Flat File via SSMS to SQL Server fails
body: <p>When importing a seemingly valid flat file (csv, text etc) into a SQL Server database using the SSMS Import Flat File option, the following error appears:</p>
  
  <blockquote>
    <p><strong>Microsoft SQL Server Management Studio</strong></p>
    
    <p>Error inserting data into table. (Microsoft.SqlServer.Import.Wizard)</p>
    
    <p>Error inserting data into table. (Microsoft.SqlServer.Prose.Import)</p>
    
    <p>Object reference not set to an instance of an object. (Microsoft.SqlServer.Prose.Import)</p>
  </blockquote>
  
  <p>The target table may contain rows that imported just fine. The first row that is not imported appears to have no formatting errors.</p>
  
  <p>What's going wrong?</p>