title: How to bulk insert 20 100mb CSV files into SQL Server
body: <p>I have about 20 .csv files which are around 100-200mb each. </p>
  
  <p>They each have about 100 columns. </p>
  
  <p>90% of the columns of each file are the same; however, some files have more columns and some files have less columns.</p>
  
  <p>I need to import all of these files into one table in a sql server 2008 database.</p>
  
  <p>If the field does not exist, I need it to be created.</p>
  
  <p><strong>question</strong>: What should be the process with this import? How do I more efficiently and quickly import all of these files into one table in a database, and make sure that if a field does not exist, then it is created? Please also keep in mind that the same field <strong>might</strong> be in a different location. For example, CAR can be in field <strong>AB</strong> in one csv whereas the same field name (CAR) can be <strong>AC</strong> in the other csv file. The solution can be SQL or C# or both.</p>