title: Easiest way to import CSV into SQl Server 2005
body: <p>I have several files about 5k each of CSV data I need to import into SQL Server 2005.</p>
  
  <p>This used to be simple with DTS.  I tried to use SSIS previously and it seemed to be about 10x as much effort and I eventually gave up.</p>
  
  <p>What would be the simplest way to import the csv data into sql server?  Ideally, the tool or method would create the table as well, since there are about 150 fields in it, this would simplify things.</p>
  
  <p>Sometimes with this data, there will be 1 or 2 rows that may need to be manually modified because they are not importing correctly.</p>