Export (0) Print
Expand All

How to: Add or Remove an Integration Services Project in a Solution

The following procedures descibe how to add or remove an Integration Services project in a solution.

You can only add a project to an existing solution, or remove a project from a solution, when the solution is visible in Business Intelligence Development Studio. If you have selected the Always show solution option in Microsoft Visual Studio, Business Intelligence Development Studio will display a solution even when that solution contains only one project. Otherwise, Business Intelligence Development Studio will display a solution only when that solution contains more than one project. The additional projects can be either SSIS projects or projects of other types.

When you add a project, you can have Integration Services create a new, blank project, or you can add a project that you have already created for a different solution. You can only add a project to an existing solution when the solution is visible in Business Intelligence Development Studio.

To add a new Integration Services project to a solution

  1. In Business Intelligence Development Studio, open the solution to which you want to add a new Integration Services project, and do one of the following:

    • Right-click the solution, click Add, and then click New Project.

    • On the File menu, point to Add, and then click New Project.

  2. In the Add New Project dialog box, click Integration Services Project in the Templates pane.

  3. Optionally, edit the project name and location.

  4. Click OK.

To add an existing Integration Services project to a solution

  1. In Business Intelligence Development Studio, open the solution to which you want to add an existing Integration Services project, and do one of the following:

    • Right-click the solution, point to Add, and then click Existing Project.

    • On the File menu, click Add, and then click Existing Project.

  2. In the Add Existing Project dialog box, browse to locate the project you want to add, and then click Open.

  3. The project is added to the solution folder in Solution Explorer.

You can only remove a project from a solution when the solution is visible in Business Intelligence Development Studio. After the solution is visible, you can remove all except one project. As soon as only one project remains, Business Intelligence Development Studio no longer displays the solution folder and you cannot remove the last project.

To remove an Integration Services project from a solution

  1. In Business Intelligence Development Studio, open the solution from which you want to remove an Integration Services project.

  2. In Solution Explorer, right-click the project, and then click Exclude From Project.

  3. In Solution Explorer, right-click the project, and then click Remove.

  4. Click OK to confirm the removal.

Community Additions

ADD
Show:
© 2014 Microsoft