This topic has not yet been rated - Rate this topic

Save Copy of Package

SQL Server 2012

Use the Save Copy of Package dialog box, available in SQL Server Data Tools (SSDT), to save a copy of an Integration Services package from SQL Server Data Tools (SSDT) to a different location and, optionally, modify the protection level of the package.

Options

Package location

Select the type of storage location in which to save the package copy. The following options are available:

SQL Server

File System

SSIS Package Store

Server

Type a server name or select a server from the list. This option is available only if the storage location is SQL Server or SSIS Package Store.

Authentication

Select Windows Authentication or SQL Server Authentication. This option is available only if the storage location is SQL Server.

Important
Whenever possible use Windows Authentication.

Authentication type: Select an authentication type.
User name: If using SQL Server Authentication, provide a user name.
Password: If using SQL Server Authentication, provide a password.

Package path

Type the package path, or click the browse (…) button and locate the folder in which to store the package.

Protection level

Click the browse (…) button and update the protection level in the Package Protection Level dialog box. For more information, see Package and Project Protection Level Dialog Box.

Tasks

Save Packages

Import and Export Packages (Legacy SSIS Service)

Reference

Import Package Dialog Box UI Reference

Export Package Dialog Box UI Reference

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD