Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Select Destination Location (SSIS Package Upgrade Wizard)

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

NoteNote

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

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 How to: 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 Managing Packages.

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.