Skip to main content

    BI in SQL vNext

    New

    Bulk generation of Integration Services packages

    Vote (4) Share
    Gerald Britton's profile image

    Gerald Britton on 15 Jun 2015 20:44:37

    When you need to process hundreds of tables in Integration Services, it becomes tedious and error prone, not to mention extraordinarily time-consuming.

    We need a way to generate ssis packages for hundreds of tables from a generic template, perhaps only pointing to the database from which the tables will be sourced and the destination database

    Comments (1)
    Gerald Britton's profile image Profile Picture

    Gösta Boström on 05 Jul 2020 22:02:02

    RE: Bulk generation of Integration Services packages

    BIML already exists, and then SSIS Templates seem to be coming in 2016.