Package Deployment (SSIS)
SQL Server Integration Services includes tools and wizards that make it simple to deploy packages from the development computer to the production server or to other computers.
There are four steps in the package deployment process:
The first optional step is optional and involves creating package configurations that update properties of package elements at run time. The configurations are automatically included when you deploy the packages.
The second step is to build the Integration Services project to create a package deployment utility. The deployment utility for the project contains the packages that you want to deploy
The third step is to copy the deployment folder that was created when you built the Integration Services project to the target computer.
The fourth step is to run, on the target computer, the Package Installation Wizard to install the packages to the file system or to an instance of SQL Server.
For information about how to create a deployment utility, see Create a Deployment Utility.
For information about how to deploy packages using the deployment utility, see Deploy Packages by Using the Deployment Utility.
For information about how to create package configurations, see Create Package Configurations.