Choose a Data Source (SQL Server Import and Export Wizard)
Use the Choose a Data Source page to specify the source of the data that you want to copy.
To learn more about this wizard, see Importing and Exporting Data by Using the 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 How to: 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 Using the Copy Database Wizard.
The following sections show the options available for several data sources. Not all the data sources that are available in the Data Source drop-down are listed here.
Data Source = SQL Server Native Client and Microsoft OLE DB Provider for SQL Server
Data Source = .NET Framework Data Provider for SQL Server
This page presents an alphabetical list of options for the .NET Framework Data Provider for SQL Server. The most important options are listed in the following table.
The additional options that are listed when you select this provider are not required to connect successfully to the SQL Server source database. For a description of these additional options, see the documentation for the .NET Framework Data Provider for SQL Server in the .NET Framework Software Development Kit.
Data Source = Microsoft Excel
Select Microsoft Excel only if you want to connect to a data source that uses Excel 2003 or earlier. To connect to a data source that uses Excel 2007, select Microsoft Office 12.0 Access Database Engine OLE DB Provider, click Properties, and then on the All tab of the Data Link Properties dialog box, enter Excel 12.0 as the value for Extended Properties.
When you import data from a Microsoft Excel source, the wizard uses the Integration Services Excel Source component. For information about usage considerations and known issues, see Excel Source.
Data Source = Microsoft Access
Select Microsoft Access only if you want to connect to a database that uses Access 2003 or earlier. To connect to a database that uses Access 2007, select Microsoft Office 12.0 Access Database Engine OLE DB Provider instead.
Data Source = Flat File Source
See the following topics for information about the options for a flat file data source.