• Phil Parkin (3/5/2015)


    Nevyn, the idea of having multiple environments in the same SSISDB instance for Dev/QA/Prod etc makes me shudder.

    There is too much risk of running a package with the wrong env and screwing things up.

    Dev, QA, prod etc should have their own SSISDB instances, in my opinion, to reduce the likelihood of needing to search for another job at short notice 😀

    Point taken.

    The steps are the same, however. Just in that model you'd deploy to the multiple DBs which each had one environment, and configure each.