Save SSIS Package (SQL Server Import and Export Wizard)

  • Article

Use the Save SSIS Package page to name, describe, and save a Microsoft SQL Server 2005 Integration Services (SSIS) package to the SQL Server msdb database or to a file that has the .dtsx extension.

To learn more about this wizard, see Creating Packages Using the SQL Server Import and Export Wizard. To learn about the options for starting the wizard, and about the permissions required to run the wizard successfully, see How to: Start the SQL Server Import and Export Wizard.

The purpose of the SQL Server Import and Export Wizard is to copy data from a source to a destination. The wizard can also create a destination database and destination tables for you. However, if you have to copy multiple databases or tables, or other kinds of database objects, you should use the Copy Database Wizard instead. For more information, see Using the Copy Database Wizard.

Static Options

  • Name
    Provide a unique name for the package.
  • Description
    Provide a description for the package. As a best practice, describe the package in terms of its purpose, to make packages self-documenting and easier to maintain.
  • Target
    View the target (SQL Server or file) that was previously specified for the destination file.

Target Dynamic Options

Target = SQL Server

  • Server name
    When you have selected a SQL Server destination, type or select the destination server name.
  • Use Windows Authentication
    When you have selected a SQL Server destination, specify whether to connect to the server by using Windows Integrated Authentication. This is the preferred authentication method.
  • Use SQL Server Authentication
    When you have selected a SQL Server destination, specify whether to connect to the server by using SQL Server Authentication.
  • User name
    When you have selected a SQL Server destination, and have specified SQL Server Authentication, type the SQL Server user name.
  • Password
    When you have selected a SQL Server destination, and have specified SQL Server Authentication, type the SQL Server password.

Target = File System

  • File name
    When you have selected a file destination, type the path for the destination file, or use the Browse button.
  • Browse
    When you have selected a file destination, browse to the destination file by using the Save Package dialog box.

See Also

Other Resources

Saving Packages

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

17 July 2006
Changed content:
  • Noted that you should use the Copy Database Wizard if you have to copy multiple databases or tables, or copy other kinds of database objects.