Any Suggestions On How To Make 1 Flow Do Many Dimensional Tables

OK looking for anyone out there that may have already tackled this and what they may have learned
I have multiple flat files providing dimensional data to multiple tables. The source files and destination tables are very similiar in structure, the columns are named differently in each table

ID - surrogate key
Code - match for lookup
Desc - updated column

flow options I have considered or might work are:
source (flat file) - this is easy to make dynamic

lookup against existing Table -

1. I can make this dynamic on the advanced tab by restricting memory. have not really tried this option yet. Seems like it might be a performance issue for large tables but so far it seems all these dimensional tables will be small.
2. Could create a view in the control flow,before execution of the DataFlow with generic column names against a variable table and use this same view for every lookup - again not sure of performance etc
3. could just replace this with a merge/join as long as it does full outer, have not used this option so I'm not quite clear on the dynamic properties

now the last part update or insert
Insert

1. Seems like I could use the OLEDB destination and make the table a variable - have not tried to see if this works.

Update-

1. looking at the OLEDB command but not sure how it would handle a variable table name in an update statement - will need to try this out
2. OLEDB command that calls a proc that executes a dynamically built update statement
3. Write the update items to a generic holding table then run an update in the control flow from a dymanically built sql statement.