Lesson 1-2 - Creating the Deployment Project

In Integration Services, the deployable unit is an Integration Services project. Before you can deploy packages, you must create a new Integration Services project and add all the packages and any ancillary files that you want to deploy with the packages to that project.

To create the Integration Services project

  1. Click Start, point to All Programs, point to Microsoft SQL Server, and then click SQL ServerSQL Server Data Tools.

  2. On the File menu, point to New, and then 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 Deployment Tutorial. Optionally, clear the Create directory for solution check box.

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

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

  7. Click OK.

  8. By default, an empty package, named Package.dtsx, is created and added to your project. However, you will not use this package; instead, you will add existing packages to the project. Because all the packages in a project will be included in the deployment, you should delete Package.dtsx. To delete it, right-click it, and then click Delete.

Next Task in Lesson

Step 3: Adding Packages and Other Files

See Also

Integration Services (SSIS) Projects