title: Use SSIS to import multiple .csv files that each have unique columns
body: <p>I keep running into issues creating a SSIS project that does the following:
  inspects folder for .csv files -> for each csv file -> insert into [db].[<em>each .csv files' name</em>]</p>
  
  <p>each csv and corresponding table in the database have their own unique columns</p>
  
  <p>i've tried the foreach loop found in many write ups but the issue comes down to the flat file connection.  it seems to expect each csv file has the same columns as the file before it and errors out when not presented with this column names.</p>
  
  <p>anyone aware of a work around for this?</p>