Share via

  • Article

Lesson 1: Creating a SQL Server ODBC Data Source

In this lesson, you create the SQL Server ODBC data source. The data source can be a user data source or a system data source.

To create the ODBC data source, you run the SQL Server DSN Configuration Wizard that is included with ODBC Data Source Administrator. For information on how to use the wizard, see the ODBC Data Source Administrator Help.

To run the SQL Server DSN Configuration Wizard

  1. Open the ODBC Data Source Administrator as described in the topic, How to: Open the ODBC Data Source Administrator.

  2. On the User DSN tab or the System DSN tab, click Add to add a user data source or a system data source.

  3. Click SQL Native Client or SQL Server Native Client 10.0 to select the driver, and then click Finish.

  4. Follow the instructions in the Wizard.

    When you use the SQL Server DSN Configuration Wizard to create the ODBC data source, you need to configure the data source to connect to the AdventureWorks2008R2 database. Otherwise, when you run the package, data will not be exported from the data source to the existing text file. To ensure that the data source is configured to connect to the AdventureWorks2008R2 database, in the wizard, for Change the default database to, select AdventureWorks2008R2.