title: BULK INSERT into specific columns?
body: <p>I want to bulk insert columns of a csv file to specific columns of a destination table. 
  Description - destination table has more columns than my csv file. So, I want the csv file columns to go to the right target columns using BULK INSERT.</p>
  
  <p>Is this possible ? If yes, then how do I do it ?</p>
  
  <p>I saw the tutorial and code at - <a href="http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-server/">http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-server/</a></p>
  
  <p>and <a href="http://www.codeproject.com/Articles/439843/Handling-BULK-Data-insert-from-CSV-to-SQL-Server">http://www.codeproject.com/Articles/439843/Handling-BULK-Data-insert-from-CSV-to-SQL-Server</a></p>
  
  <pre><code>BULK INSERT dbo.TableForBulkData
  FROM 'C:\BulkDataFile.csv'
  WITH
  (
  FIELDTERMINATOR = ',',
  ROWTERMINATOR = '\n'
  )
  </code></pre>
  
  <p>They don't show you how you can control where data is inserted.</p>