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

In this lesson, you create the Integration Services project in Business Intelligence Development Studio. You will run the SQL Server Import and Export Wizard from this project.

To create the Integration Services project from which to run the SQL Server Import and Export Wizard

  1. On the Start menu, point to All Programs, point to Microsoft SQL Server, and click SQL ServerBusiness Intelligence Development Studio.

  2. On the File menu, point to New, and click Project to create a new Integration Services project.

  3. In the New Project dialog box, in the Templates pane, select Integration Services Project.

  4. In the Name box, change the default name to Export ODBC to Flat File Tutorial.

  5. (Optional) Clear the Create directory for solution check box.

  6. Accept the default location, or click Browse to browse to locate the folder you want to use.

  7. In the Project Location dialog box, click the folder and click Open.

  8. Click OK.

    By default, Business Intelligence Development Studio creates an empty package, named Package.dtsx, and adds this package to every new project. However, you will not use this package because the wizard will create its own package. You can delete Package.dtsx, or use it as the basis for a different package later. To delete it, right-click Package.dtsx, and then click Delete.

Lesson 3: Running the Wizard 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.

Community Additions