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 Server Business 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.