title: How to set multiple SSIS variables in SQL Task
body: <p>Say I want to get the key values of two tables and assign to two package variables. </p>
  
  <p>I can easily assign one, setting the Execute SQL Task to return a single row. But is it possible to set multiple variables with multiple result sets?</p>
  
  <p>I have this SQL:</p>
  
  <pre><code>SELECT COALESCE(MAX(LogKey),0) AS LogKey FROM Log
  SELECT COALESCE(MAX(HeaderKey),0) AS HKey FROM Header
  </code></pre>
  
  <p>I've tried setting the <code>ResultSet</code> property to both single row and Full result set, but neither seem to work. Do I have to use a separate Execute SQL task?</p>