crystalkmfk.blogg.se

FolderĬontains Project Connection Managers. The following table describes the folders that appear in an Integration Services project. The following diagram shows the folders in an Integration Services project in SQL Server Data Tools (SSDT). After you understand what a project contains, you can begin creating and working with an Integration Services project.

For example, a project includes the files that are required to create a specific extract, transfer, and load (ETL) solution.īefore you create an Integration Services project, you should become familiar with the basic contents of this kind of project. In SQL Server Data Tools (SSDT), an Integration Services project stores and groups the files that are related to the package. Integration Services projects contain packagesĪ project is a container in which you develop Integration Services packages. 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. The *.suo file contains information about your preferences for working with the solution. The *.sln file contains information about the solution configuration and lists the projects in the solution. 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.

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). Solutions can include different types of projects. 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 contain projectsĪ solution is a container that groups and manages the projects that you use when you develop end-to-end business solutions. On the General page, select Always show solution. In the Options dialog box, expand Projects and Solutions, and then click General. To change this default behavior, on the Tools menus, click Options. By default, when you create a new project in SQL Server Data Tools, the solution is not shown in Solution Explorer pane.