You don't need to use ActiveX, you just need to set up Global Variable and use it as an output parameter for an execute SQL task.
In your case, you'd place your select query in the SQL task, click parameters, go to output parameters, and select Rowset. Then choose the Global Variable you would like to assign your rowset to from the drop down menu.
Hope this helps,
Alex
Professor: But what about your superintelligence?
Gunther: When I had that there was too much pressure to use it. All I want out of life is to be a monkey of moderate intelligence who wears a suit. That's why I've decided to transfer to Business School.
Professor: NOOOOOOOOOOOO.