This topic has not yet been rated - Rate this topic

Upgrading the Packages (SSIS Package Upgrade Wizard)

SQL Server 2008 R2

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.

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

To view upgraded packages that were upgraded from Business Intelligence Development Studio

In Business Intelligence Development Studio, in Solution Explorer, open the Integration Services project, and then expand the SSIS Packages node to see the upgraded packages.

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.

Concepts

Upgrading Integration Services Packages

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD