Edit

Share via

Choose a Data Source (SQL Server Import and Export Wizard)

  • Article

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

After the Welcome page, the SQL Server Import and Export Wizard displays Choose a Data Source. On this page, you provide information about the source of your data and about how to connect to it.

For info about the data sources that you can use, see What data sources and destinations can I use?

Note

The SQL Server Import and Export Wizard utilizes SQL Server Integration Services (SSIS). Therefore the same limitations that apply to SSIS, also apply to the wizard. For example ErrorCode and ErrorColumn columns, which are added by default as described in Error handling in data.

Screen shot of the Choose a Data Source page

The following image shows the first part of the Choose a Data Source page of the wizard. The rest of the page has a variable number of options which depend on the data source that you choose here.

Choose source

Choose a data source

Data source
Specify the data source by selecting a data provider that can connect to the source.

  • The data provider that you need is typically obvious from its name, because the name of the provider typically contains the name of the data source - for example, Flat File Source, Microsoft Excel, Microsoft Access, .Net Framework Data Provider for SqlServer, .Net Framework Data Provider for Oracle.

  • If you have an ODBC driver for your data source, select the .Net Framework Data Provider for ODBC. Then enter the driver-specific info. ODBC drivers aren't listed in the drop-down list of data sources. The .Net Framework Data Provider for ODBC acts as a wrapper around the ODBC driver. For more info, see Connect to an ODBC Data Source.

  • There may be more than one provider available for your data source. Typically you can select any provider that works with your source. For example, to connect to Microsoft SQL Server, you can use the .NET Framework Data Provider for SQL Server or the SQL Server ODBC driver. (Other providers are also still in the list but are no longer supported.)

My data source isn't in the list

  • You may have to download the data provider from Microsoft or from a third party. The list of available data providers in the Data source list includes only the providers installed on your computer. For info about the data sources that you can use, see What data sources and destinations can I use?

  • Do you have an ODBC driver for your data source? ODBC drivers aren't listed in the drop-down list of data sources. If you have an ODBC driver for your data source, select the .Net Framework Data Provider for ODBC. Then enter the driver-specific info. The .Net Framework Data Provider for ODBC acts as a wrapper around the ODBC driver. For more info, see Connect to an ODBC Data Source.

  • 64-bit and 32-bit providers. If you're running the 64-bit wizard, you won't see data sources for which only a 32-bit provider is installed, and vice versa.

Note

To use the 64-bit version of the SQL Server Import and Export Wizard, you have to install SQL Server. SQL Server Data Tools (SSDT) and SQL Server Management Studio (SSMS) are 32-bit applications and only install 32-bit files, including the 32-bit version of the wizard.

After you choose a data source

After you choose a data source, the rest of the Choose a Data Source page has a variable number of options which depend on the data provider that you choose.

To connect to a commonly used data source, see one of the following pages.

For info about how to connect to a data source that's not listed here, see The Connection Strings Reference. This third-party site contains sample connection strings and more info about data providers and the connection info they require.

What's next?

After you provide info about the source of your data and about how to connect to it, the next page is Choose a Destination. On this page, you provide info about the destination for your data and about how to connect to it. For more info, see Choose a Destination.

See also

Get started with this simple example of the Import and Export Wizard

Get help

Contribute to SQL documentation

Did you know that you can edit SQL content yourself? If you do so, not only do you help improve our documentation, but you also get credited as a contributor to the page.

For more information, see How to contribute to SQL Server documentation