Save SSIS Package (SQL Server Import and Export Wizard)
Use the Save SSIS Package page to name, describe, and save a Microsoft SQL Server Integration Services (SSIS) package to the SQL Server msdb database or to a file that has the .dtsx extension.
Note
In SQL Server Express, the option to save the package created by the wizard is not available.
To learn more about this wizard, see Using the SQL Server Import and Export Wizard to Move Data. To learn about the options for starting the wizard, and about the permissions required to run the wizard successfully, see How to: Run 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.