It appears there is a cozyrock component available to support dynamics.

http://www.cozyroc.com/ssis/data-flow-task

This is an example of an implementation of the cozyrock component:

http://informatics.northwestern.edu/blog/edw/2011/08/introducing-etl-assistant/

It might complicate things if you require the solution to...