How to: Start the SQL Server Import and Export Wizard

The SQL Server Import and Export Wizard offers the simplest method of building a Microsoft SQL Server 2005 Integration Services (SSIS) package.

The SQL Server Import and Export Wizard can access a variety of data sources. You can copy data to and from the following sources:

• Microsoft SQL Server
• Flat files
• Microsoft Office Access
• Microsoft Office Excel
• Other OLE DB providers

Additionally, you can use ADO.NET providers and ODBC data sources as sources only.

If you start the SQL Server Import and Export Wizard from an Integration Services project in Business Intelligence Development Studio, the package cannot be run immediately from the wizard. Instead the wizard adds the package to the project that you can then run the package in Business Intelligence Development Studio.

If the wizard is started in SQL Server Management Studio, you can choose whether to run the package immediately, by selecting the Execute immediately check box. By default, the package runs immediately. You can also choose whether to save the package to SQL Server or to the file system. If you select the option to save the package, you must also specify a package protection level. For more information about package protection levels, see Setting the Protection Level of Packages.

After the SQL Server Import and Export Wizard has created the package and copied the data, you can open and change the saved package by using the SSIS Designer. You can also extend the basic package functionality by adding tasks, transformations, and event-driven logic. For more information, see Creating Packages in SSIS Designer.

To complete the SQL Server Import and Export Wizard successfully, you must have at least the following permissions:

• Permissions to connect to the source and destination databases or file shares. In Integration Services, this requires server and database login rights.
• Permission to read data from the source database or file. In SQL Server 2005, this requires SELECT permissions on the source tables and views.
• Permissions to write data to the destination database or file. In SQL Server 2005, this requires INSERT permissions on the destination tables.
• If you want to create a new destination database or table or file, permissions sufficient to create the new database or table or file. In SQL Server 2005, this requires CREATE DATABASE or CREATE TABLE permissions.
• If you want to save the package created by the wizard, permissions sufficient to write to the msdb database or to the file system. In Integration Services, this requires INSERT permissions on the msdb database.
• For more information about how to manage permissions for Integration Services packages by using SQL Server Management Studio, see Integration Services Roles.

To start the SQL Server Import and Export Wizard

• In Business Intelligence Development Studio, right-click the SSIS Packages folder, and then click SSISImport and Export Wizard.

  —or—

  In Business Intelligence Development Studio, on the Project menu, click SSISImport and Export Wizard.

  —or—

  In SQL Server Management Studio, connect to the Database Engine server type, expand Databases, right-click a database, point to Tasks, and then click Import Data or Export data.

  —or—

  In a command prompt window, run DTSWizard.exe, located in C:\Program Files\Microsoft SQL Server\90\DTS\Binn.

See Also

Tasks

Creating Packages Using the SQL Server Import and Export Wizard
How to: Create a Package Using SSIS Designer

Concepts

Package How-to Topics (SSIS)

Help and Information

Getting SQL Server 2005 Assistance