You could do this with a foreach loop container, with the sql task source type set to a variable and an initial sql task creating dynamic SQL code into an...
I was trying to achieve something similar recently and decided it probably wasn't possible without breaking the relationship between the tables, as the data won't be committed till after...