SSIS environments and deployment

242 Views Asked by At

I use SQL Server 2012 with Visual studio 2010 with Integration Services Catalog. I would like to know if it is possible to deploy my ssis 2012 project to only one of the three environments I have created. I am trying to understand if this is possible or if environments are created only for different variable values (for different test scenarios etc). So my question is if I can have deployment version 1 on my DEV environment and deployment version 2 on another environment. Thank you

1

There are 1 best solutions below

6
On

Sure it's possible. It's the opposite of what most people want, but you can create a DEV version of your package and only deploy it to your DEV environment, and then create a 2nd version of the package and only deploy it to your 2nd environment.

Note that I am talking about having two separate .dtsx packages, which will have to be maintained separately. That is what I think you are asking. If I have misunderstood, then your question wasn't clear.