title: How do I generate a primary key using SSIS?
body: <p>I'm mucking about with SSIS and can't figure out how to generate a primary key?</p>
  
  <p>I have a very simple SSIS Data Flow:</p>
  
  <pre><code>Excel File Source -&gt; Character Map -&gt; ADO.NET Destination
  </code></pre>
  
  <p>The Excel file has the following structure:</p>
  
  <pre><code>Field1
  </code></pre>
  
  <p>The destination table has the following structure:</p>
  
  <pre><code>ID - UniqueIdentifier (GUID)
  Field1
  </code></pre>
  
  <p>There's no problem mapping Field1, but how do I get ID to map to the NEWID() SQL Server function (or something equivalent like the .NET method System.Guid.NewGuid()).</p>