Write the results of your SQL query out to a variable, try single row first, if you have a full result set then it gets a little more tricky.
1 . Create a string variable eg: @resultsfromquery.
2. In you SQL Task container, choose ResultSet Single row
3. Choose Result Set from the menu on the side GENERAL, ParameterMapping, Result Set, Expressions.
4. Set the Result Name to 0 and the VariableName to your variable eg: User::resultsfromquery
5. Add a breakpoint to your SQLTask, you can use Break when the container receives the OnPostExecute
6. Start Debug (F5)
7. When debug starts you will have the extra option of adding a WATCH window.
8. When the watch window appears drag your variable onto the watch window.
When your package hits the breakpoint, you will then see your results appear in your variable.
If you are doing a full result set you will need to set up a for each loop container :-)
Hope this helps