title: Insert a single row and return its primary key
body: <p>In SSIS, How do I use the execute SQL task to insert a single row with no parameters and get the primary key back so I can set it to user variable? My insert query is simply:</p>
  
  <pre><code>INSERT INTO [AdWords.ImportData] (EndDate) VALUES (null)
  </code></pre>