The deployment models are they way SSIS packages are developed in SSIS 2012.
You have two models:
* the package deployment model: the unit of deployment is a single package. This is how it has always been since SSIS 2005.
* the project deployment model: packages now reside in a project. You can only deploy projects, not individual packages. You can use the new parameters and project connection managers.
ps: what's wrong with doing automated stuff on a production server? I don't like anything "manual" on a production server.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP