• SSIS is metadata-driven and as you have found an out of the box setup needs to be modified each time the set of source or destination columns that need to be sent through a Data Flow are changed.

    If you're open to a third-party tool and some experimenting this tries to address your issue:

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

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato