title: SSIS user variable not updating in execute SQL task
body: <p>I know this should be really simple, but I cannot get it to work. I am using an execute SQL Task in Control flow with the intention of setting 2 user_variables, vRunID and vRelease. I have a very simple select statement where I am getting a single row, 2 columns:</p>
  
  <pre><code>SELECT Id, release
  FROM [Test].[Run] 
  where id = (select max(id) FROM [Test].[Run])
  </code></pre>
  
  <p>in the result set tab, I have tried mapping using "Result Name"s of both the columns (Id and Release) and 0,1 to the "Variable Name"s of User::vRunID and User::vRelease. I cannot get the variable values to change at all. If I hardcode the variable values, everything runs fine, but I would like it to be based off of the select statement so we can just run the package and not have to hard code the values (which is why we use SSIS in the first place)
  Is there something simple I'm missing? Do I need to set something in the parameters? Watching countless online videos it looks like I have everything set up as I should, but it will not load the values.</p>