Export (0) Print
Expand All
0 out of 7 rated this helpful - Rate this topic

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 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 SQL Server Import and Export Wizard. To learn about the options for starting the wizard, and about 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.

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.