TechNet
Export (0) Print
Expand All

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

 

Updated: July 25, 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.

For more info about the SQL Server Import and Export Wizard and how it works, see SQL Server Import and Export Wizard.

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. 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

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.

System_CAPS_ICON_note.jpg Note

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

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.

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 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.

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 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:
© 2016 Microsoft