Deploying Integration Services Projects

The last step in the Integration Services project deployment journey is the deployment of the project. After having created packages for the project, package configurations, and the deployment utility, there isn’t much left other than actually running the deployment utility to deploy the Integration Services project.

As you create the deployment utility, a manifestation file with the extension SSISDeploymentManifest is created along with packages, configurations, and miscellaneous files in the folder specified in the DeploymentOutputPath property of Integration Services project. You need to copy this deployment folder to the deployment computer and execute the SSISDeploymentManifest file to install the ...

Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.