• I'd recommend using Cozyroc for this.  The Data Flow+ Task SSIS component has the capability to dynamically map columns on the fly



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]