SSIS Package Upgrade Wizard F1 Help

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

Use the SSIS Package Upgrade Wizard to upgrade packages created by earlier versions of SQL Server to the package format for the current release of SQL Server Integration Services.

To run the SSIS Package Upgrade Wizard

SSIS Upgrade Wizard

Options

Do not show this page again.
Skip the Welcome page the next time that you open the wizard.

Select Source Location page

Use the Select Source Location page to specify the source from which to upgrade packages.

Note

This page is only available when you run the SSIS Package Upgrade Wizard from SQL Server Management Studio or at the command prompt.

Static Options

Package source
Select the storage location that contains the packages to be upgraded. This option has the values listed in the following table.

Value Description
File System Indicates that the packages to be upgraded are in a folder on the local computer.

To have the wizard back up the original packages before upgrading those packages, the original packages must be stored in the file system. For more information, see How To Topic.
SSIS Package Store Indicates that the packages to be upgraded are in the package store. The package store consists of the set of file system folders that the Integration Services service manages. For more information, see Package Management (SSIS Service).

Selecting this value displays the corresponding Package source dynamic options.
Microsoft SQL Server Indicates the packages to be upgraded are from an existing instance of SQL Server.

Selecting this value displays the corresponding Package source dynamic options.

Folder
Type the name of a folder that contains the packages you want to upgrade or click Browse and locate the folder.

Browse
Browse to locate the folder that contains the packages you want to upgrade.

Package Source Dynamic Options

Package source = SSIS Package Store

Server
Type the name of the server that has the packages to be upgraded, or select this server in the list.

Package source = Microsoft SQL Server

Server
Type the name of the server that has the packages to be upgraded, or select this server from the list.

Use Windows authentication
Select to use Windows Authentication to connect to the server.

Use SQL Server authentication
Select to use SQL Server Authentication to connect to the server. If you use SQL Server Authentication, you must provide a user name and password.

User name
Type the user name that SQL Server Authentication will use to connect to the server.

Password
Type the password that SQL Server Authentication will use to connect to the server.

Select Destination Location page

Use the Select Destination Location page to specify the destination to which to save the upgraded packages.

Note

This page is only available when you run the SSIS Package Upgrade Wizard from SQL Server Management Studio or at the command prompt.

Static Options

Save to source location
Save the upgraded packages to the same location as specified on the Select Source Location page of the wizard.

If the original packages are stored in the file system and you want the wizard to back up those packages, select the Save to source location option. For more information, see Upgrade Integration Services Packages Using the SSIS Package Upgrade Wizard.

Select new destination location
Save the upgraded packages to the destination location that is specified on this page.

Package source
Specify where the upgrade packages are to be stored. This option has the values listed in the following table.

Value Description
File System Indicates that the upgraded packages are to be saved to a folder on the local computer.
SSIS Package Store Indicates that the upgraded packages are to be saved to the Integration Services package store. The package store consists of the set of file system folders that the Integration Services service manages. For more information, see Package Management (SSIS Service).

Selecting this value displays the corresponding Package source dynamics options.
Microsoft SQL Server Indicates that the upgraded packages are to be saved to an existing instance of SQL Server.

Selecting this value displays the corresponding dynamic Package source dynamic options.

Folder
Type the name of a folder to which the upgraded packages will be saved, or click Browse and locate the folder.

Browse
Browse to locate the folder to which the upgraded packages will be saved.

Package Source Dynamic Options

Package source = SSIS Package Store

Server
Type the name of the server to which the upgrade packages will be saved, or select a server in the list.

Package source = Microsoft SQL Server

Server
Type the name of the server to which the upgrade packages will be saved, or select this server in the list.

Use Windows authentication
Select to use Windows Authentication to connect to the server.

Use SQL Server authentication
Select to use SQL Server Authentication to connect to the server. If you use SQL Server Authentication, you must provide a user name and password.

User name
Type the user name to be used when using SQL Server Authentication to connect to the server.

Password
Type the password to be used when using SQL Server Authentication to connect to the server.

Select Package Management Options page

Use the Select Package Management Options page to specify options for upgrading packages.

To run the SSIS Package Upgrade Wizard

Options

Update connection strings to use new provider names
Update the connection strings to use the names for the following providers for the current release of Integration Services:

  • OLE DB Provider for Analysis Services

  • SQL Server Native Client

The SSIS Package Upgrade Wizard updates only connection strings that are stored in connection managers. The wizard does not update connection strings that are constructed dynamically by using the Integration Services expression language, or by using code in a Script task.

Validate upgrade packages
Validate the upgrade packages and save only those upgrade packages that pass validation.

If you do not select this option, the wizard will not validate upgrade packages. Therefore, the wizard will save all upgrade packages, regardless of whether the packages are valid or not. The wizard saves upgrade packages to the destination that is specified on the SelectDestination Location page of the wizard.

Validation adds time to the upgrade process. We recommend that you do not select this option for large packages that are likely to be upgraded successfully.

Create new package IDs
Create new package IDs for the upgrade packages.

Continue upgrade process when a package upgrade fails
Specify that when a package cannot be upgraded, the SSIS Package Upgrade Wizard continues to upgrade the remaining packages.

Package name conflicts
Specify how the wizard should handle packages that have the same name. This option has the values listed in the following table.

Overwrite existing package files
Replaces the existing package with the upgrade package of the same name.

Add numeric suffixes to upgrade package names
Adds a numeric suffix to the name of the upgrade package.

Do not upgrade packages
Stops the packages from being upgraded and displays an error when you complete the wizard.

These options are not available when you select the Save to source location option on the Select Destination Location page of the wizard.

Ignore Configurations
Does not load package configurations during the package upgrade. Selecting this option reduces the time required to upgrade the package.

Backup original packages
Have the wizard back up the original packages to an SSISBackupFolder folder. The wizard creates the SSISBackupFolder folder as a subfolder to the folder that contains the original packages and the upgraded packages.

Note

This option is available only when you specify that the original packages and the upgraded packages are stored in the file system and in the same folder.

Select Packages page

Use the Select Packages page to select the packages to upgrade. This page lists the packages that are stored in the location that was specified on the Select Source Location page of the wizard.

Options

Existing package name
Select one or more packages to upgrade.

Upgrade package name
Provide the destination package name, or use the default name that the wizard provides.

Note

You can also change the destination package name after upgrading the package. In SQL Server Data Tools (SSDT) or SQL Server Management Studio, open the upgraded package and change the package name.

Password
Specify the password that is used to decrypt the selected upgrade packages.

Apply to selection
Apply the specified password to decrypt the selected upgrade packages.

Complete the Wizard page

Use the Complete the Wizard page to review and confirm the package upgrade options that you have selected. This is the last wizard page from which you can go back and change options for this session of the wizard.

Options

Summary of options
Review the upgrade options that you have selected in the wizard. To change any options, click Back to return to previous wizard pages.

Upgrading the Packages page

Use the Upgrading the Packages page to view the progress of package upgrade and to interrupt the upgrade process. The SSIS Package Upgrade Wizard upgrades the selected packages one by one.

Options

Message pane
Displays progress messages and summary information during the upgrade process.

Action
View the actions in the upgrade.

Status
View the result of each action.

Message
View the error messages that each action generates.

Stop
Stop the package upgrade.

Report
Select what you want to do with the report that contains the results of the package upgrade:

  • View the report online.

  • Save the report to a file.

  • Copy the report to the Clipboard

  • Send the report as an e-mail message.

View upgraded packages

View upgraded packages that were saved to a SQL Server database or to the package store

In Management Studio, in Object Explorer, connect to the local instance of Integration Services, and then expand the Stored Packages node to see the packages that were upgraded.

View upgraded packages that were upgraded from SQL Server Data Tools

In SQL Server Data Tools (SSDT), in Solution Explorer, open the Integration Services project, and then expand the SSIS Packages node to see the upgraded packages.

See Also

Upgrade Integration Services Packages