If all the tables are in the same source DB, why not just do your query in one source and send it to your transformation?

You seem to be taking tasks into SSIS that dont really belong there, and which sql is better at.

Or at least use lookups instead of merge joining.