Project deployment is the recommended way to deploy SSIS packages to SQL Server 2014.
The whole project is deployed to SSIS Catelog database on the server.
1. Create a SSIS Catelog. The catelog come with the SSISDB database.
2. Create folder(s) under catelog
3. Right click the folder/projects and select the source project to deploy
or
Right click the project from Visual Studio and deploy to the server (step by step wizard)
4. In SSIS 2014 projection deployment mode, Project Parameters & Project Connection Managers are globally available to all packages.
So normally all packages reference to the Project Param & Connections.
5. One can create an Environment in SQL Server 2014 under the SSIS Catelog. An Environment is a set of variables such as Production database connections, username, passwords, etc.
6. Configure a deployed project, and map the Environment variables to Project parameters & connection manager strings.
In this way, the environment variables overwrite the project initial setttings.
7. Execute package from either SSIS catelog or sql agent job (a new SSIS Catelog source is available in the job).