title: good tool to quickly import some csv data into sql server
body: <p>Every once in a while I find myself typing a one-off script to import some CSV data into a database, doing some column logic (e.g. turn column3 into uppercase) and/or field mapping (column2 in the csv goes to column 3 in de database, etc).</p>
  
  <p>Is there a nice tool which can do this easier?</p>
  
  <p>The least amount of features I'd need is: </p>
  
  <ul>
  <li>choosing delimiter</li>
  <li>Being able to map column X to column Y in the DB</li>
  <li>setting defaults for columns not in the csv file</li>
  </ul>
  
  <p>SQL server management studio can almost do it, except one can not specify any defaults for values which are not listed in the csv file. So I'd then have to create extra columns in excel first.</p>