Deploy 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 Create 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.
Note
Depending on the version of the package that you are deploying, you might encounter an error if you have different versions of SQL Server installed side-by-side. This error can occur because the .SSISDeploymentManifest file name extension is the same for all versions of Integration Services. Double-clicking the file calls the installer (dtsinstall.exe) for the most recently installed version of Integration 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.
To deploy packages to an instance of SQL Server
Open the deployment folder on the target computer.
Double-click the manifest file, <project name>.SSISDeploymentManifest, to start the Package Installation Wizard.
On the Deploy SSIS Packages page, select the SQL Server deployment option.
Optionally, select Validate packages after installation to validate packages after they are installed on the target server.
On the Specify Target SQL Server page, specify the instance of SQL Server to install the packages to and select an authentication mode. If you select SQL Server Authentication, you must provide a user name and a password.
On the Select Installation Folder page, specify the folder in the file system for the package dependencies that will be installed.
If the package includes configurations, you can edit configurations by updating values in the Value list on the Configure Packages page.
If you elected to validate packages after installation, view the validation results of the deployed packages.
|
.gif "Integration Services icon (small)")
Stay Up to Date with Integration Services