Task 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 ServerBusiness Intelligence Development Studio.

  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.

Task 3: Adding Packages and Other Files

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