This topic has not yet been rated - Rate this topic

Select Source Location (SSIS Package Upgrade Wizard)

SQL Server 2008 R2

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.

To run the SSIS Package Upgrade Wizard

How to: Upgrade Integration Services Packages Using the SSIS Package Upgrade Wizard

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 Managing Packages. 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.

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 Managing Packages.

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.

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