Multi Table Source

I am wondering how I can create an OLE DB Source component that can store a multi-table DataSet object. Is this something that is possible or do I need some custom object to do this? I'm sure I can create a multi-table destination object and create sources for each data table needed however, I need to get the data for 5 tables and do this about 30K times. I'm thinking this approach will perform better.



Here is what I've been trying to get working. (Note there is only one parameter that all the queries use - @keyName)



SELECT * FROM Table1
WHERE (Key = ?)



SELECT * FROM Table2
WHERE (Key = ?)



SELECT * FROM Table3
WHERE (Key = ?)



SELECT * FROM Table4
WHERE (Key = ?)



SELECT * FROM Table5
WHERE (Key = ?)



TIA



Ian