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

    dc820169 a3bd-4df7-a515-d5fe24ee5c9f 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.