It sounds like you've done a lot of work on this... I regret to have to tell you, but you can't dynamically change the meta data of an SSIS dataflow.

The only way that you change the source or destination objects at runtime, is if they contain the same metadata, which doesn't sound like the case in your situation.