have you tried to use an expression to calculate the sql script?

You can use VB to read the small packages and create new tasks in the consolidated package but this may be more work than re-creating the transformations from scratch.

create a temporary table (or a standard table that you can re-create each time the DTS runs), replace the print statements with inserts into that table, direct DTS to output...