Export (0) Print
Expand All

Package Installation Wizard UI Reference

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.

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

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

Community Additions

ADD
Show:
© 2014 Microsoft