Connect to Data Sources with the SQL Server Import and Export Wizard

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

The topics in this section show you how to connect to many commonly used data sources when you run the SQL Server Import and Export Wizard. You have to provide connection info for your data sources on the Choose a Data Source and Choose a Destination pages of the wizard.

The topics in this section describe only how to connect to data sources from the Choose a Data Source and Choose a Destination pages of the wizard. If you're looking for something else, see Related tasks and content.

Connect to a commonly used data source

Click a link to learn more about connecting to one of the following commonly used data sources.

• SQL Server
• Oracle
• Flat files (text files)
• Excel
• Access
• Azure Blob Storage
• ODBC
• PostgreSQL
• MySQL

Connect to other data providers

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.

Related tasks and content

Here are some other basic tasks.

• See a quick example of how the wizard works.

  • If you prefer to see screen shots. Take a look at this simple end-to-end example on a single page - Get started with this simple example of the Import and Export Wizard.

  • If you prefer to watch a video. Watch this four-minute video from YouTube that demonstrates the wizard and explains clearly and simply how to export data to Excel - Using the SQL Server Import and Export Wizard to Export to Excel.

• Learn more about how the wizard works.

  • Learn more about the wizard. If you're looking for an overview of the wizard, see Import and Export Data with the SQL Server Import and Export Wizard.

  • Learn about the steps in the wizard. If you're looking for info about the steps in the wizard, see Steps in the SQL Server Import and Export Wizard. There's also a separate page of documentation for each page of the wizard.

• Start the wizard. If you're ready to run the wizard and just want to know how to start it, see Start the SQL Server Import and Export Wizard.

• Get the wizard. If you want to run the wizard, but you don't have Microsoft SQL Server installed on your computer, you can install the SQL Server Import and Export Wizard by installing SQL Server Data Tools (SSDT). For more info, see Download SQL Server Data Tools (SSDT).

See also

Choose a Data Source
Choose a Destination