Integration Services (SSIS) Projects
SQL Server provides two environments, SQL Server Data Tools (SSDT) and SQL Server Management Studio, for the development and management of Integration Services packages.
-
SQL Server Data Tools (SSDT) supports the development of Integration Services packages.
-
SQL Server Management Studio uses the Integration Services service to supports the management of Integration Services packages in test and production environments. For more information, see Use SQL Server Management Studio.
Both environments use the concept of projects within solutions to organize and manage the items that you use when you build business intelligence solutions. For more information, see Solution Explorer.
In SQL Server Management Studio and SQL Server Data Tools (SSDT), a project is a container in which you develop Integration Services packages.
In SQL Server Data Tools (SSDT), an Integration Services 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 Integration Services 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 Integration Services project.
Folders in Integration Services Projects
The following diagram shows the folders in an Integration Services project.
The following table describes the folders that appear in an Integration Services project.
|
Folder |
Description |
|---|---|
|
SSIS Packages |
Contains packages. For more information, see Integration Services (SSIS) Packages. |
|
Miscellaneous |
Contains files other than package files. |
Files in Integration Services Projects
When you add a new or an existing Integration Services project to a solution, SQL Server Data Tools (SSDT) creates project files that have the extensions .dtproj and .dtproj.user and .database.
-
The *.dtproj file contains information about project configurations and items such as packages.
-
The *.dtproj.user file contains information about your preferences for working with the project.
-
The *.database file contains information that SQL Server Data Tools (SSDT) requires to open the Integration Services project.
In SQL Server Management Studio and SQL Server Data Tools (SSDT), 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 in SQL Server Management Studio and SQL Server Data Tools (SSDT) can include different types of projects. If you want to use SSIS Designer to create an Integration Services package, you work in an Integration Services project in a solution provided by SQL Server Data Tools (SSDT).
When you create a new solution, SQL Server Data Tools (SSDT) adds a Solution folder to Solution Explorer, and creates files that have the extensions, .sln and .suo:
-
The *.sln file contains information about the solution configuration and lists the projects in the solution.
-
The *.suo file contains information about your preferences for working with the solution.
While SQL Server Data Tools (SSDT) automatically creates a solution when you create a new project, you can also create a blank solution, and then add projects later.
Note
|
|---|
|
By default, when you create a new Integration Services project in SQL Server Data Tools (SSDT), the solution is not shown in the Project Explorer pane. To change this default behavior, on the Tools menus, click Options. In the Options dialog box, expand Projects and Solutions, and then click General. On the General page, select Always show solution. |
|
