• 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.

    More info: http://www.mssqltips.com/sqlservertip/2450/ssis-package-deployment-model-in-sql-server-2012-part-1-of-2/

    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