title: Bulk Insert into SQL Server from text file adding a uniqueidentifier, or skipping a column
body: <p>I need to take rows from a text file and insert into a table. The rows of the file are similar to the following:</p>
  
  <pre><code>string1
  string2
  string3
  string4
  ...
  </code></pre>
  
  <p>My table has 2 columns: </p>
  
  <pre><code>uniqueidentifier, stringValue
  </code></pre>
  
  <p>I would like to do a bulk insert into the table grabbing each row from the text file and adding a new <code>uniqueidentifier</code> to each one (ideally a GUID, but an integer counter would be fine).</p>
  
  <p>Anyone have a tip on how to do this bulk upload? So far my SQL is:</p>
  
  <pre><code>BULK
  INSERT tableNameToInsertInto
  FROM 'C:\importList.txt'
  WITH
  (
  ROWTERMINATOR = '\n'
  )
  GO
  </code></pre>