title: Can you add to an SSIS object variable, appending?
body: <p>We have an SSIS package that calls a Stored Proc to populate a variable object (full result set).</p>
  
  <p>This is fine.</p>
  
  <p>Now we have a need to call that same stored proc again but with different parameters.  So really two sets of data that we want stored all together in the same variable object.  </p>
  
  <p>If I populate it a second time, does it overwrite what was there, or append to it?</p>
  
  <p>I do this</p>
  
  <pre><code>Execute SQL Task
  ResultSet = Full result set
  SQLStatement - executes the stored procedure etc.
  Result Set 
  Result Name = 0
  Variable Name = User::Subscriptions
  </code></pre>
  
  <p>I want that to stay.  But want to have a second Execute SQL Task that does the exact same thing, just executes the same stored proc with a different parameter.  And I want the <code>User::Subscription</code> variable to hold the results of the 1st <code>Execute SQL Task</code> plus the 2nd <code>Execute SQL task</code>.  Is this possible?</p>