TechNet
Export (0) Print
Expand All

Development of an Integration Services Project

 

Applies To: SQL Server 2016

You add Integration Services packages to projects. To create and work with Integration Services projects, you must install the SQL Server Data Tools (SSDT) environment. For more information, see Install Integration Services.

When you create a new Integration Services project in SQL Server Data Tools (SSDT), 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 Integration Services project to the solution. If no solution exists, SQL Server Data Tools (SSDT) automatically creates one for you when you first create the project. A solution can contain multiple projects of different types.

System_CAPS_ICON_note.jpg Note


By default, when you create a new Integration Services project in SQL Server Data Tools, the solution is not shown in the Solution 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.

Community Additions

ADD
Show:
© 2016 Microsoft