Save and Run Package (SQL Server Import and Export Wizard)

 

Updated: August 22, 2016

Applies To: SQL Server 2016

After you specify and configure your data source and destination, the SQL Server Import and Export Wizard shows Save and Run Package. On this page, you specify whether you want to run the copy operation immediately. Depending on your configuration, you may also be able to save the SQL Server Integration Services package created by the wizard to customize it and to reuse it later.

The Wizard uses SQL Server Integration Services (SSIS) to copy data. In SSIS, the basic unit is the package. The wizard creates an SSIS package in memory as you move through the pages of the wizard and specify options. For more info, see The Wizard uses SQL Server Integration Services (SSIS).

The following screen shot shows the Save and Run Package page of the wizard.

Save and run package page of the Import and Export Wizard

Options

To continue, you have to select at least one of the following two options.

Run immediately
Select this option to run the package immediately.

Save SSIS Package
Save the package. Later you can optionally customize the package and run it again. If you choose to save the package, there are additional options on the next page, Save SSIS Package. The option to save the package is available only if you have SQL Server Standard Edition or a higher edition installed.

System_CAPS_ICON_note.jpg Note

If you finish the wizard, run the package, and then stop a package before it finishes running, the package is not saved, even if you selected the Save check box on this page.

Options for saving the package

SQL Server
Select this option to save the package in the msdb database in the sysssispackages table.

You select the target server and provide credentials to connect to the server on the next page, Save SSIS Package. For more info, see Save SSIS Package.

System_CAPS_ICON_note.jpg Note

This option does not save the package to the SSIS Catalog database (SSISDB).

File system
Select this option to save the package as a file that has the .dtsx extension.

You select the target folder and file name for the package on the next page, Save SSIS Package. For more info, see Save SSIS Package.

Package protection level
Select a protection level from the list to help protect the data in the package.

The protection level determines the protection method, the password or user key, and the scope of package protection. Protection can include all data or sensitive data only. For more info about the available options, see Access Control for Sensitive Data in Packages.

Password
Type a password.

Retype password
Type the password again.

System_CAPS_ICON_note.jpg Note

The password options are available only if you set the Package protection level option to either Encrypt sensitive data with password or Encrypt all data with password.

The method that you use to start the wizard determines whether you can run and save the package that the wizard creates.

How you start the wizardCan you run the package?Can you save the package?
You start the wizard from the Start menu, from the command prompt, or from SQL Server Management Studio.You can run the package immediately at the end of the wizard by selecting the Execute immediately check box. By default, this check box is selected and the package runs immediately.If you have SQL Server Standard Edition or higher installed, you can optionally save the package.
You start the wizard from an Integration Services project in SQL Server Data Tools (SSDT).You can't run the package until after you exit the wizard. Then you can run the package in SQL Server Data Tools.The wizard saves the package in the Integration Services project from which you started the wizard.

The Save and Run Package page is one of two pages on which you pick options for saving the SSIS package.

  • On the current page, you pick whether to save the package in SQL Server or as a file. You also pick security settings for the saved package.

  • Next, on the Save SSIS Package page, you provide a name for the package and more info about where to save it. For more info, see Save SSIS Package.

These options are available only if you select the Save SSIS Package option on this page.

After you specify whether to run the copy operation immediately and whether to save the package, the next page depends on the options that you choose.

  • If you selected the option to run the package immediately, but not to save it, the next page is Complete the Wizard. On this page, you review the choices that you made in the wizard, and then start the copy operation. For more info, see Complete the Wizard.

  • If you selected the option to save the package, the next page is Save SSIS Package. On this page, you specify additional options for saving the package. (Then, after you save the package, the following page is Complete the Wizard.) For more info, see Save SSIS Package.

Run Integration Services (SSIS) Packages
Save Packages

Community Additions

ADD
Show: