Home Forums SQL Server 2005 Business Intelligence SSIS: Automatically map source to destination when new columns are added. RE: SSIS: Automatically map source to destination when new columns are added.

  • August 5, 2010 at 5:24 am

    #1202636

    Nope, there isn't such a thing in SSIS. SSIS is awful when it comes to handling metadata changes.

    However, it can be possible that there are commercial components who can do this. (check out CozyRoc).

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP