• Tim ffitch (1/21/2016)


    I can see where this would be useful for multiple environments on the same server. When dealing with multiple servers then it would be better to create your environments in Data Tools/Visual Studio using package and project parameters with different values set up for each server. This is one areas where 2012 is so much better than 2008.

    I'm not sure how you would specify different values in SSDT for each server?

    You mean by using "visual studio configurations"? Like in this article:

    https://www.mssqltips.com/sqlservertip/3513/using-visual-studio-configurations-in-sql-server-integration-services-projects/

    I still create one environment per server. So scripting the environment would be useful if I add a new server.

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