Integration Services Wizards

SQL Server Import and Export Wizard

The SQL Server Import and Export Wizard provides the simplest method of copying data between data sources and of constructing basic packages.

The SQL Server Import and Export Wizard can copy data to and from any data source for which a .NET Framework or a native OLE DB data provider is available. The following data sources are some of the sources for which there is an appropriate data provider:

• SQL Server 

• Flat files

• Microsoft Access

• Microsoft Excel

After specifying the source and destination, you select the data to import or export.

Depending on the source and destination types, you then set additional wizard options. For example, if you are copying data between SQL Server databases, you specify the tables or views from which to copy data, or provide an SQL statement that selects the data.

Finally, to perform the import or export, you run the Integration Services package that the wizard has created. Optionally, you can save the package, and then use SSIS Designer to extend the package by adding tasks, transformations, and event-driven logic. For more information, see Designing Packages in Business Intelligence Development Studio.

You can start the SQL Server Import and Export Wizard from the Start menu, from SQL Server Management Studio, or from Business Intelligence Development Studio. For more information, see How to: Run the SQL Server Import and Export Wizard.

For a video that demonstrates how to use the SQL Server Import and Export Wizard to create a package that exports data from a SQL Server database to a Microsoft Excel spreadsheet, see Exporting SQL Server Data to Excel (SQL Server Video).

Integration Services Connections Project Wizard

You use the Integration Services Connections Project Wizard to create a package that contains the connection information that is required to connect data sources and destinations. The wizard guides you through the steps of selecting data providers, configuring connection managers, and assigning connection managers to sources and destinations.

For more information, see Creating a Package by Running a Wizard.

Package Installation Wizard

The Package Installation Wizard guides you through the process of deploying packages and updating package configurations.

Before you deploy packages, you can create configurations and then deploy them with the packages. Integration Services uses configurations to dynamically update properties of packages and package objects at run time. For example, the connection string of an OLE DB connection can be set dynamically at run time by providing a configuration that maps a value to the property that contains the connection string.

You cannot run the Package Installation Wizard until you build an Integration Services project and create a deployment utility. For more information, see Deploying Packages by Using the Deployment Utility.

Package Configuration Wizard

The Package Configuration Wizard guides you though the steps to create the configurations that update the values of properties of packages and package objects at run time. This wizard runs when you add a new configuration or modify an existing one in the Package Configurations Organizer dialog box. (To open the Package Configurations Organizer dialog box, in Business Intelligence Development Studio, on the SSIS menu, select Package Configurations.)

For more information, see Creating Package Configurations.

See Also

Concepts