Save SSIS Package (SQL Server Import and Export Wizard)
Updated: August 22, 2016
Applies To: SQL Server 2016
If you specified on the Save and Run Package page that you want to save the SSIS package created by the wizard, the SQL Server Import and Export Wizard shows Save SSIS Package. On this page, you specify additional options for saving the package.
The Wizard uses SQL Server Integration Services (SSIS) to copy data. In SSIS, the basic unit is the package. For more info, see The Wizard uses SQL Server Integration Services (SSIS).
The options that you see on the Save SSIS Package page depend on the choice that you made previously on the Save and Run Package page to save the package to SQL Server or to the file system. To take another look at the Save and Run Package page, see Save and Run Package.
The following screen shot shows the Save SSIS Package page of the wizard after you select the File system option on the Save and Run Package page.
The following screen shot shows the Save SSIS Package page of the wizard after you select the SQL Server option on the Save and Run Package page.
Provide a unique name for the package.
Provide a description for the package. As a best practice, describe the purpose of the package, to make packages self-documenting and easier to maintain.
The destination (SQL Server or file) that you previously specified for the package. If you want to save the package to a different destination, go back to the Save and Run Package page.
When you have selected a file system destination, complete the following fields.
Type the path and filename for the destination file, or use the Browse button to select a destination.
Be sure to specify a destination folder, either by typing or by browsing. If you only type the filename without a path, you don't know where the wizard saves the package. Also, the wizard may try to save the package to a location where you don't have permission to save a file, and raise an error.
Remember where you save the package file.
Optionally, browse to select the path for the destination file by using the Save Package dialog box.
When you have selected a SQL Server destination, complete the following fields.
Type or select the destination server name.
The wizard saves the package in the msdb database in the sysssispackages table .
This option does not save the package to the SSIS Catalog database (SSISDB).
Use Windows Authentication
Specify whether to connect to the server by using Windows Integrated Authentication. This is the preferred authentication method.
Use SQL Server Authentication
Specify whether to connect to the server by using SQL Server Authentication.
When you have specified SQL Server Authentication, type the SQL Server user name.
When you have specified SQL Server Authentication, type the SQL Server password.
The Save SSIS Package page is one of two pages on which you pick options for saving the SSIS package.
On the previous page, Save and Execute Package, you pick whether to save the package in SQL Server or as a file. You also pick security settings for the saved package. To take another look at the Save and Run Package page, see Save and Run Package.
On the current page, you provide a name for the package and more info about where to save it.
To learn how to run the saved package again later, see one the following topics.
To run a package by using a utility program with a friendly user interface, see Execute Package Utility (DtExecUI) UI Reference.
To run a package from the command line or from a batch file, see dtexec Utility.
If you saved the package in the file system, see Run a Package in SQL Server Data Tools to run the package in the development environment. You have to add the package to an Integration Services project before you can open and run it.
If you saved the package in SQL Server in the msdb database, connect to the Integration Services service. Then, in SQL Server Management Studio, in Object Explorer, navigate to Stored Packages | MSDB, right-click on the package, and select Run Package.
To learn how to customize the saved package, see Integration Services (SSIS) Packages.
After you specify additional options for saving the package, the next page is Complete the Wizard. On this page, you review the choices that you made in the wizard, and then you start the operation. For more info, see Complete the Wizard.