Deploy SSIS Packages

To deploy SQL Server Integration Services packages, you use the Package Installation Wizard. By using this wizard, you can deploy packages to one of two locations:

  • To an instance of SQL Server.

  • To the file system.

The procedures in this topic describe how to deploy packages to each of these locations.

Before you can run the Package Installation Wizard, you must copy the deployment folder, which was created when you built a deployment utility, to the target computer.

To deploy packages to an instance of SQL Server

  1. Open the deployment folder on the target computer.

  2. Double-click the manifest file, <project name>.SSISDeploymentManifest, to start the Package Installation Wizard.

  3. On the Deploy SSIS Packages page, select the SQL Server deployment option.

  4. Optionally, select Validate packages after installation to validate packages after they are installed on the target server.

  5. 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.

  6. On the Select Installation Folder page, specify the folder in the file system for the package dependencies that will be installed.

  7. If the package includes configurations, you can edit configurations by updating values in the Value list on the Configure Packages page.

  8. If you elected to validate packages after installation, view the validation results of the deployed packages.


To deploy packages to the file system

  1. Open the deployment folder on the target computer.

  2. Double-click the manifest file, <project name>.SSISDeploymentManifest, to start the Package Installation Wizard.

  3. On the Deploy SSIS Packages page, select the File system deployment option.

  4. Optionally, select Validate packages after installation to validate the packages after they are installed on the target server.

  5. On the Select Installation Folder page, specify the folder in which to install packages and package dependencies.

  6. If the package includes configurations, you can edit updatable configurations by updating values in the Value list on the Configure Packages page.

  7. If you elected to validate packages after installation, view the validation results of the deployed packages.
Mr. Ravi Krishna - Senior Software Engineer
I am a Mocrosoft ASP.net Developer and MCP Certified professional. I have overall 5 years of experience in IT Industry,in that 3 years experience in Microsoft BI(SSAS,SSIS,SSRS). I have experience on various business domains like Automation and Chemical.
https://sites.google.com/site/rkkumardotnet/
Read moreRead more about Contributor