• Article

Step 1: Creating the Integration Services Project

This tutorial uses the SQL Server Import and Export Wizard to create a basic package by running the wizard in Business Intelligence Development Studio. The wizard is launched from an Integration Services project. In this task you will create an Integration Services project.

To create the Integration Services project

  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, select Integration Services Project in the Templates pane.

  4. In the Name box, change the default name to SQL Server Import and Export Wizard Tutorial. Optionally, clear the Create directory for solution check box.

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

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

  7. Click OK.

  8. By default, an empty package, named Package.dtsx, is created and added 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 it and then click Delete.