To do this you will need to use a resultset in your execute SQL task.

Edit the task and under the general tab change the resulset setting to the one you need.

Then under the resulset tab add the variable that you need the resultset mapped to