| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Integration Services (SSIS) Projects and Solutions |
Integration Services (SSIS) Projects and Solutions |
chugugrace |
chugu |
vanto, mikeray |
09/17/2024 |
sql |
integration-services |
conceptual |
|
|
[!INCLUDE sqlserver-ssis]
[!INCLUDE ssNoVersion] provides [!INCLUDE ssBIDevStudioFull] for the development of [!INCLUDE ssISnoversion] packages.
[!INCLUDE ssISnoversion] packages reside in projects. To create and work with [!INCLUDE ssISnoversion] projects, you must install SQL Server Data Tools. For more information, see Install Integration Services.
When you create a new [!INCLUDE ssISnoversion] project in [!INCLUDE ssBIDevStudioFull], the New Project dialog box includes an Integration Services Project template. This project template creates a new project that contains a single package.
Projects are stored in solutions. You can create a solution first and then add an [!INCLUDE ssISnoversion] project to the solution. If no solution exists, [!INCLUDE ssBIDevStudioFull] automatically creates one for you when you first create the project. A solution can contain multiple projects of different types.
Tip
By default, when you create a new project in [!INCLUDE ssBIDevStudio], the solution is not shown in Solution Explorer pane. To change this default behavior, on the Tools menus, select Options. In the Options dialog box, expand Projects and Solutions, and then select General. On the General page, select Always show solution.
A solution is a container that groups and manages the projects that you use when you develop end-to-end business solutions. A solution lets you handle multiple projects as one unit and to bring together one or more related projects that contribute to a business solution.
Solutions can include different types of projects. If you want to use [!INCLUDE ssIS] Designer to create an [!INCLUDE ssISnoversion] package, you work in an [!INCLUDE ssISnoversion] project in a solution provided by [!INCLUDE ssBIDevStudioFull].
When you create a new solution, [!INCLUDE ssBIDevStudioFull] adds a solution folder to Solution Explorer. The solution folder contains these types of files:
-
.sln: contains information about the solution configuration and lists the projects in the solution. -
.suo: contains information about your preferences for working with the solution.
While [!INCLUDE ssBIDevStudioFull] automatically creates a solution when you create a new project, you can also create a blank solution, and then add projects later.
A project is a container in which you develop [!INCLUDE ssISnoversion] packages.
In [!INCLUDE ssBIDevStudioFull], an [!INCLUDE ssISnoversion] project stores and groups the files that are related to the package. For example, a project includes the files that are required to create a specific extract, transfer, and load (ETL) solution.
Before you create an [!INCLUDE ssISnoversion] project, you should become familiar with the basic contents of this kind of project. After you understand what a project contains, you can begin creating and working with an [!INCLUDE ssISnoversion] project.
The following image shows the folders in an [!INCLUDE ssISnoversion] project in [!INCLUDE ssBIDevStudioFull].
:::image type="content" source="media/ssis-solution-explorer.png" alt-text="Screenshot of Solution Explorer showing the folders in the project.":::
The following table describes the folders that appear in an [!INCLUDE ssISnoversion] project.
| Folder | Description |
|---|---|
| Connection Managers | Contains Project Connection Managers. For more information, see Integration Services (SSIS) Connections. |
| [!INCLUDE ssIS] Packages | Contains packages. For more information, see Integration Services (SSIS) Packages. |
| Package Parts | Contains Package Parts that can be reused or imported. For more information, see Reuse Control Flow across Packages by Using Control Flow Package Parts |
| Miscellaneous | Contains files other than package files. |
When you add a new or an existing [!INCLUDE ssISnoversion] project to a solution, [!INCLUDE ssBIDevStudioFull] creates project files. Project files include:
-
.dtproj: contains information about project configurations and items such as packages. -
*.dtproj.user: contains information about your preferences for working with the project. -
*.database: contains information that [!INCLUDE ssBIDevStudioFull] requires to open the [!INCLUDE ssISnoversion] project. -
Project.params: contains information about the Project parameters.
In [!INCLUDE ssBIDevStudioFull], you can create, maintain, and run packages that target specific versions of SQL Server.
In Solution Explorer, right-click on an Integration Services project and select Properties to open the property pages for the project. On the General tab of Configuration Properties, select the TargetServerVersion property, and then choose the version you want.
:::image type="content" source="media/targetserverversion2.png" alt-text="Screenshot of TargetServerVersion property in project properties dialog box." lightbox="media/targetserverversion2.png":::
-
Open [!INCLUDE ssBIDevStudioFull].
-
On the File menu, point to New, and then select Project.
-
In the New Project dialog box, select Business Intelligence, and then select the Integration Services Project template.
The Integration Services Project template creates an [!INCLUDE ssISnoversion] project that contains a single, empty package.
:::image type="content" source="media/ssis-ssdt-new-project.png" alt-text="Screenshot of the New Project dialog box with the Integration Services Project - Business Intelligence template highlighted." lightbox="media/ssis-ssdt-new-project.png":::
-
(Optional) Edit the project name and the location.
The solution name is automatically updated to match the project name.
-
To create a separate folder for the solution file, select the default option, specifically Create directory for solution.
-
If source control software is installed on the computer, select Add to source control to associate the project with source control.
-
If the source control software is [!INCLUDE msCoName] Visual SourceSafe, the Visual SourceSafe Login dialog box opens. In Visual SourceSafe Login, provide a user name, a password, and the name of the [!INCLUDE msCoName] Visual SourceSafe database. Select Browse to locate the database.
[!NOTE]
To view and change the selected source control plug-in and to configure the source control environment, select Options on the Tools menu, and then expand the Source Control node. -
Select OK to add the solution to Solution Explorer and add the project to the solution.
-
In [!INCLUDE vsprvs], select New > Project on the File menu.
-
In the Installed Templates area of the New Project window, expand Business Intelligence, and select Integration Services.
-
Select Integration Services Import Project Wizard from the project types list.
-
Type a name for the new project to be created in the Name text box.
-
Type the path or location for the project in the Location text box, or select Browse to select one.
-
Type a name for the solution in the Solution name text box.
-
Select OK to launch the Integration Services Import Project Wizard dialog box.
-
Select Next to switch to the Select Source page.
-
If you're importing from an
.ispacfile, type the path including file name in the Path text box. Select Browse to navigate to the folder where you want the solution to be stored and type file name in the File name text box, and select Open.If you're importing from an Integration Services Catalog, type the database instance name in the Server name text box or select Browse and select the database instance that contains the catalog.
Select Browse next to Path text box, expand folder in the catalog, select the project you want to import, and select OK.
Select Next to switch to the Review page.
-
Review the information and select Import to create a project based on the existing project you selected.
-
Optional: select Save Report to save the results to a file
-
Select Close to close the Integration Services Import Project Wizard dialog box.
When you add a project, you can have [!INCLUDE ssISnoversion] 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 [!INCLUDE ssBIDevStudioFull].
-
In [!INCLUDE ssBIDevStudioFull], open the solution to which you want to add a new [!INCLUDE ssISnoversion] project, and either:
- Right-click the solution, select Add, and then select New Project.
or
- On the File menu, point to Add, and then select New Project.
-
In the Add New Project dialog box, select Integration Services Project in the Templates pane.
-
Optionally, edit the project name and location.
-
Select OK.
-
In [!INCLUDE ssBIDevStudioFull], open the solution to which you want to add an existing [!INCLUDE ssISnoversion] project, and do one of the following:
-
Right-click the solution, point to Add, and then select Existing Project.
-
On the File menu, select Add, and then select Existing Project.
-
-
In the Add Existing Project dialog box, browse to locate the project you want to add, and then select Open.
-
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 [!INCLUDE ssBIDevStudioFull]. After the solution is visible, you can remove all except one project. As soon as only one project remains, [!INCLUDE ssBIDevStudioFull] no longer displays the solution folder. You can't remove the last project.
-
In [!INCLUDE ssBIDevStudioFull], open the solution from which you want to remove an [!INCLUDE ssISnoversion] project.
-
In Solution Explorer, right-click the project, and then select Unload Project.
-
Select OK to confirm the removal.
-
In [!INCLUDE ssBIDevStudioFull], open the solution that contains the [!INCLUDE ssISnoversion] project to which you want to add an item.
-
In Solution Explorer, right-click the project, point to Add, and do one of the following:
-
Select New Item, and then select a template from the Templates pane in the Add New Item dialog box.
-
Select Existing Item, browse in the Add Existing Item dialog box to locate the item you want to add to the project, and then select Add.
-
-
The new item appears in the appropriate folder in Solution Explorer.
You can copy objects within an [!INCLUDE ssISnoversion] project or between [!INCLUDE ssISnoversion] projects. You can also copy objects between the other types of [!INCLUDE ssBIDevStudioFull] projects, [!INCLUDE ssRSnoversion] and [!INCLUDE ssASnoversion]. To copy between projects, the project must be part of the same [!INCLUDE ssBIDevStudioFull] solution.
-
In [!INCLUDE ssBIDevStudioFull], open the [!INCLUDE ssISnoversion] project or solution that you want to work with.
-
Expand the project and item folder to copy from.
-
Right-click the item and select Copy.
-
Right-click the [!INCLUDE ssISnoversion] project to copy to and select Paste.
The items are automatically copied to the correct folder. If you copy items to the [!INCLUDE ssISnoversion] project that aren't packages, the items are copied to the Miscellaneous folder.