Export (0) Print
Expand All

Deploying Packages by Using the Deployment Utility

When you have built a deployment utility to install packages from an Integration Services project on a different computer than the one on which the deployment utility was built, you must first copy the deployment folder to the destination computer.

The path of the deployment folder is specified in the DeploymentOutputPath property of the Integration Services project for which you created the deployment utility. The default path is bin\Deployment, relative to the Integration Services project. For more information, see Creating a Deployment Utility.

You use the Package Installation Wizard to install the packages. To launch the wizard, double-click the deployment utility file after you have copied the deployment folder to the server. This file is named <project name>.SSISDeploymentManifest, and can be found in the deployment folder on the destination computer.

NoteNote

Depending on the version of the package that you are deploying, you might encounter an error if you have SQL Server 2005 and SQL Server 2008 installed side-by-side. This error can occur because the .SSISDeploymentManifest file name extension is the same for both SQL Server 2005Integration Services and SQL Server 2008Integration Services. Double-clicking the file calls the installer (dtsinstall.exe) for the most recently installed version of SQL ServerIntegration Services, which might not be the same version as the deployment utility file. To work around this problem, run the correct version of dtsinstall.exe from the command line, and provide the path of the deployment utility file.

The Package Installation Wizard guides you through the steps to install packages to the file system or to SQL Server. You can configure the installation in the following ways:

  • Choosing the location type and location to install the packages.

  • Choosing location to install package dependencies.

  • Validating the packages after they are installed on the target server.

The file-based dependencies for packages are always installed to the file system. If you install a package to the file system, the dependencies are installed in the same folder as the one that you specify for the package. If you install a package to SQL Server, you can specify the folder in which to store the file-based dependencies.

If the package includes configurations that you want to modify for use on the destination computer, you can update the values of the properties by using the wizard.

In addition to installing packages by using the Package Installation Wizard, you can copy and move packages by using the dtutil command prompt utility. For more information, see dtutil Utility.

NoteNote

To become better acquainted with the concepts explained in this section, see Tutorial: Deploying Packages.

To install packages

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Updated content

  • Added note about the error that can occur when you deploy packages on a computer that has both SQL Server 2005 and SQL Server 2008 installed.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft