One thing to be careful about whenever you're using dynamic SQL in SSIS - if you're ever thinking of putting that data into a destination table or file through a data flow task, and your source is using dynamic SQL, you *will* run in to problems.

Since your solution isn't doing that, it shouldn't be an issue, but for anyone who is taking this idea and trying to adapt it to their own work, keep that in mind.