TechNet
Export (0) Print
Expand All

Package Installation Wizard UI Reference

 

Applies To: SQL Server 2016

Use the Package Installation Wizard to deploy a Integration Services project, including the packages and miscellaneous files it contains and any package dependencies.

Before you deploy packages, you can create configurations and then deploy them with the packages. Integration Services uses configurations to dynamically update properties of packages and package objects at run time. For example, the connection string of an OLE DB connection can be set dynamically at run time by providing a configuration that maps a value to the property that contains the connection string.

You cannot run the Package Installation Wizard until you build an Integration Services project and create a deployment utility. For more information, see Deploy Packages by Using the Deployment Utility.

The following sections describe pages of the wizard.

Use the Package Installation Wizard to deploy an Integration Services project for which you built a package deployment utility.

Do not show this starting page again
Select to skip the starting page when you run the wizard again.

Next
Go to the next page in the wizard.

Finish
Skip to the Finish the Package Installation Wizard page. Use this option if you have backtracked through the wizard pages to revise your choices and have specified all of the required options.

Use the Configure Packages page to edit package configurations.

Options

Configuration file
Edit the contents of a configuration file by selecting the file from the list.

Related Topics: Create Package Configurations

Path
View the path of the property to be configured.

Type
View the data type of the property.

Value
Specify the value of the configuration.

Next
Go to the next page in the wizard.

Finish
Skip to the Finish the Package Installation Wizard page. Use this option if you have backtracked through the wizard pages to revise your choices and have specified all of the required options.

Use the Confirm Installation page to start the installation of packages, to view the status, and to view the information that the wizard will use to install files from the specified project.

Next
Install the packages and their dependencies and go to the next wizard page when installation is completed.

Status
Shows the progress of the package installation.

Finish
Go to the Finish the Package Installation Wizard page. Use this option if you have backtracked through the wizard pages to revise your choices and have specified all the required options.

Use the Deploy SSIS Packages page to specify where to install Integration Services packages and their dependencies.

Options

File system deployment
Deploy packages and dependencies in a specified folder in the file system.

SQL Server deployment
Deploy packages and dependencies in an instance of SQL Server. Use this option if SQL Server shares packages between servers. Any package dependencies are installed in the specified folder in the file system.

Validate packages after installation
Indicate whether to validate packages after installation.

Next
Go to the next page in the wizard.

Finish
Skip to the Finish the Package Installation Wizard page. Use this option if you have backtracked through the wizard pages to revise your choices and have specified all of the required options.

Use the Packages Validation page to view the progress and results of the package validation.

Next
Go to the next page in the wizard.

Use the Select Installation Folder page to specify the file system folder in which to install the packages and their dependencies.

Options

Folder
Specify the path and folder in which to copy the package and its dependencies.

Browse
Browse to the target folder by using the Browse For Folder dialog box.

Next
Go to the next page in the wizard.

Finish
Skip to the Finish the Package Installation Wizard page. Use this option if you have backtracked through the wizard pages to revise your choices and if have specified all of the required options.

Use the Specify Target SQL Server page to specify options for deploying the package to an instance of SQL Server.

Options

Server name
Specify the name of the server to deploy the packages to.

Use Windows Authentication
Specify whether to use Windows Authentication to log on to the server. Windows Authentication is recommended for better security.

Use SQL Server Authentication
Specify whether the package should use SQL Server Authentication to log on to the server. If you use SQL Server Authentication, you must provide a user name and password.

User name
Specify a user name.

Password
Specify a password.

Package path
Specify the name of the logical folder, or enter "/" for the default folder.

To select the folder in the SSIS Package dialog box, click browse (...). However, the dialog box does not provide a means to select the default folder. If you want to use the default folder, you have to enter "/" in the text box.

System_CAPS_ICON_note.jpg Note


If you do not enter a valid package path, the following error message appears: "One or more arguments are invalid."

Rely on server storage for encryption
Select to use security features of the Database Engine to help secure the packages.

Next
Go to the next page in the wizard.

Finish
Skip to the Finish the Package Installation Wizard page. Use this option if you have backtracked through the wizard pages to revise your choices and have specified all of the required options.

Use the Finish the Package Installation Wizard page to view a summary of the package installation results. This page provides details such as the name of the deployed Integration Services project, the packages that were installed, the configuration files, and the installation location.

Finish
Exit the wizard by clicking Finish.

Legacy Package Deployment (SSIS)

Community Additions

ADD
Show:
© 2016 Microsoft