Export (0) Print
Expand All

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

Use the Save and Execute Package dialog box to run the package immediately, save it to run later, or both.

Note Note

If you stop a package before it finishes running, the package is not saved, even if you selected the Save check box.

To learn more about this wizard, see SQL Server Import and Export Wizard. To learn about the options for starting the wizard, as well as the permissions required to run the wizard successfully, see 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 Use the Copy Database Wizard.

Execute immediately

Select this option to run the package immediately.

Save SSIS Package

Save the package to run later, with the option to run it immediately.

Note Note

In SQL Server Express, the option to save the package created by the wizard is not available.

SQL Server

Select this option to save the package to the Microsoft SQL Server msdb database.

Note Note

This option is available only if you have selected the Save SSIS Package option.

File system

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

Note Note

This option is available only if you have selected the Save SSIS Package option.

Package protection level

Select a protection level from the list.

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. To understand the requirements and options for package security, see Access Control for Sensitive Data in Packages and Security Overview (Integration Services).

Note Note

This option is available only if you have selected the Save SSIS Package option.

Password

Type a password.

Note Note

This option is available only if you have set the Package protection level option to either Encrypt sensitive data with password or Encrypt all data with password.

Retype password

Type the password again.

Note Note

This option is available only if you have set the Package protection level option to either Encrypt sensitive data with password or Encrypt all data with password.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft