Development of an Integration Services Project

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 and Solutions

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.

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.

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN:


For automatic notification of these updates, subscribe to the RSS feeds available on the page.