Integration Services Project Conversion Wizard

 

Applies To: SQL Server 2016

The Integration Services Project Conversion Wizard converts a project to the project deployment model.

System_CAPS_ICON_note.jpg Note


If the project contains one or more datasources, the datasources are removed when the project conversion is completed. To create a connection to a data source that can be shared by the packages in the project, add a connection manager at the project level. For more information, see Add, Delete, or Share a Connection Manager in a Package.

What do you want to do?

Do one of the following to open the Integration Services Project Conversion Wizard.

  • Open the project in Visual Studio, and then in Solution Explorer, right-click the project and click Convert to Project Deployment Model.

  • From Object Explorer in Management Studio, right-click the Projects node and select Import Packages.

Depending on whether you run the Integration Services Project Conversion Wizard from Visual Studio or from SQL Server Management Studio, the wizard performs different conversion tasks. For more information, see Deploy Projects to Integration Services Server.

System_CAPS_ICON_note.jpg Note


The Locate Packages page is available only when you run the wizard from Management Studio.

The following option displays on the page when you select File system in the Source drop-down list. Select this option when the package is resides in the file system.

Folder
Type the package path, or navigate to the package by clicking Browse.

The following options display on the page when you select SSIS Package Store in the Source drop-down list. For more information about the package store, see Package Management (SSIS Service).

Server
Type the server name or select the server.

Folder
Type the package path, or navigate to the package by clicking Browse.

The following options display on the page when you select Microsoft SQL Server in the Source drop-down list. Select this option when the package resides in Microsoft SQL Server.

Server
Type the server name or select the server.

Use Windows authentication
Microsoft Windows Authentication mode allows a user to connect through a Windows user account. If you use Windows Authentication, you do not need to provide a user name or password.

Use SQL Server authentication
When a user connects with a specified login name and password from a non-trusted connection, SQL Server authenticates the connection by checking to see if a SQL Server login account has been set up and if the specified password matches the one previously recorded. If SQL Server does not have a login account set, authentication fails, and the user receives an error message.

User name
Specify a user name when you are using SQL Server Authentication.

Password
Provide the password when you are using SQL Server Authentication.

Folder
Type the package path, or navigate to the package by clicking Browse.

Package Name
Lists the package file.

Status
Indicates whether a package is ready to convert to the project deployment model.

Message
Displays a message associated with the package.

Password
Displays a password associated with the package. The password text is hidden.

Apply to selection
Click to apply the password in the Password text box, to the selected package or packages.

Refresh
Refreshes the list of packages.

On this page, specify the name and path for a new project deployment file (.ispac) or select an existing file.

System_CAPS_ICON_note.jpg Note


The Select Destination page is available only when you run the wizard from Management Studio.

Output path
Type the path for the deployment file or navigate to the file by clicking Browse.

Project name
Type the project name.

Protection level
Select the protection level. For more information, see Access Control for Sensitive Data in Packages.

Project description
Type an optional description for the project.

System_CAPS_ICON_note.jpg Note


The Specify Project Properties page is available only when you run the wizard from Visual Studio.

Project name
Lists the project name.

Protection level
Select a protection level for the packages contained in the project. For more information about protection levels, see Access Control for Sensitive Data in Packages.

Project description
Type an optional project description.

Update Execute Package Tasks contain in the packages, to use a project-based reference. For more information, see Execute Package Task Editor.

Parent Package
Lists the name of the package that executes the child package using the Execute Package task.

Task name
Lists the name of the Execute Package task.

Original reference
Lists the current path of the child package.

Assign reference
Select a child package stored in the project.

Select the package configurations that you want to replace with parameters.

Package
Lists the package file.

Type
Lists the type of configuration, such as an XML configuration file.

Configuration String
Lists the path of the configuration file.

Status
Displays a status message for the configuration. Click the message to view the entire message text.

Add Configurations
Add package configurations contained in other projects to the list of available configurations that you want to replace with parameters. You can select configurations stored in a file system or stored in SQL Server.

Refresh
Click to refresh the list of configurations.

Remove configurations from all packages after conversion
It is recommended that you remove all configurations from the project by selecting this option.

If you don’t select this option, only the configurations that you selected to replace with parameters are removed.

Select the parameter name and scope for each configuration property.

Package
Lists the package file.

Parameter Name
Lists the parameter name.

Scope
Select the scope of the parameter, either package or project.

Name
Lists the parameter name.

Scope
Lists the scope of the parameter.

Value
Lists the parameter value.

Click the ellipsis button next to the value field to configure the parameter properties.

In the Set Parameter Details dialog box, you can edit the parameter value. You can also specify whether the parameter value must be provided when you run the package.

You can modify value in the Parameters page of the Configure dialog box in Management Studio, by clicking the browse button next to the parameter. The Set Parameter Value dialog box appears.

The Set Parameter Details dialog box also lists the data type of the parameter value and the origin of the parameter.

Use the Review page to confirm the options that you’ve selected for the conversion of the project.

Previous
Click to change an option.

Convert
Click to convert the project to the project deployment model.

The Perform Conversion page shows status of the project conversion.

Action
Lists a specific conversion step.

Result
Lists the status of each conversion step. Click the status message for more information.

The project conversion is not saved until the project is saved in Visual Studio.

Save report
Click to save a summary of the project conversion in an .xml file.

Deploy Projects to Integration Services Server

Community Additions

ADD
Show: