i couldn't seem to find a 2008 SSIS forum.
No, there isn't one - at least last time I checked. But there is a generic SSIS forum here which seems to be used by those running 2008 and later ...
That article looks promising. One additional complexity you will face is around datatypes - somehow, you'll need to assess the queries' column datatypes (if you use the same method as in the article). My brain is heating up just imagining that 🙂
But your existing method must get round this somehow, so you should be OK.
Good luck - sounds like a fun little project.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.