• 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 AdventureWorks 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 AdventureWorks database, in the wizard, for Change the default database to, select AdventureWorks.

Next Lesson

Lesson 2: Creating an Integration Services Project to Export from ODBC to a Flat File

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.