bellis' solution is the way to go.  You could add a sql task and store the resultset to a global variable.

An example of a query that I use to do...

Another approach you might try is to save the results of each of your sql statements to global variables. (under execute sql task properties, create a global variable in...