How to: Export a Package Using Integration Services Service

This procedure describes how to export packages that are stored in an instance of Microsoft SQL Server, the file system, or the SSIS Package Store. You can export a package to a different storage format and location.

To export a package

  1. Click Start, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.

  2. In the Connect to Server dialog box, set the following options:

    • In the Server type box, select Integration Services.
    • In the Server name box, provide a server name or click <Browse for more…> and locate the server to use.
  3. If Object Explorer is not open, on the View menu, click Object Explorer.

  4. In Object Explorer, expand the Stored Packages folder.

  5. Expand the subfolders to locate the package you want to export.

  6. Right-click the package, click Export, and then do one of the following:

    • To export to an instance of SQL Server, select the SQL Server option, and then specify the server and select the authentication mode. If you select SQL Server Authentication, provide a user name and a password.
      Click the browse button (…), and expand the SSIS Packages folder to locate the folder to which you want to save the package. Optionally, update the default name of the package, and then click OK.
    • To export to the file system, select the File System option.
      Click the browse button (…) to locate the folder to which you want to export the package, type the name of the package file, and then click Save.
    • To export to the SSIS package store, select the SSIS Package Store option, and specify the server.
      Click the browse button (…), expand the SSIS Packages folder, and select the folder to which you want to save the package. Optionally, enter a new name for the package in the Package Name text box. Click OK.
  7. To update the protection level of the package, click the browse button (…) and choose a different protection level by using the Package Protection Level dialog box. If the Encrypt sensitive data with password or the Encrypt all data with password option is selected, type and confirm a password.

  8. Click OK to complete the export.

See Also

Tasks

Importing and Exporting Packages

Concepts

Integration Services Packages
Setting the Protection Level of Packages
Package How-to Topics (SSIS)

Help and Information

Getting SQL Server 2005 Assistance