Integration Services (SSIS) and Visual Studio Team Foundation Server

  • Article

You can use the suite of tools in Visual Studio 2012 and the Visual Studio Team Foundation Server 2012 to manage the lifecycle of SSIS projects. You can also use earlier versions of Visual Studio with Team Foundation Server.

Microsoft Visual Studio Team Foundation Server, the core of the application lifecycle management tools, provides version control, a build system, and tools and metrics for managing and organizing projects. With a license for Team Explorer, you can view and update data in Team Foundation Server by using Team Web Access, Visual Studio and other integrated development environments. For more information, see Application Lifecycle Management with Visual Studio and Team Foundation Server

The following table lists the file extensions of the files that make up an SSIS project. Certain changes that you make to during development will result in changes to the project file (.dtproj), including modifying package parameters, modifying package connection managers, and adding and removing packages, shared connection managers, and project parameters.

File Extension

Description

.dtsx

Package file.

.params

File stores project parameters.

.dtproj

Project file.

.dtproj.user

File contains user specific information.

.conmgr

Shared connection manager file.

.sln

Visual Studio solution file.

.dtproj.vspscc

Auto-generated file used by Team Foundation Server.

.vssscc

Auto-generated file used by Team Foundation Server.

.database

File created by SQL Server BI projects in Visual Studio and not used by SSIS.

For more information about working with SSIS and Visual Studio Team Foundation Server, and best practices for doing team development, see Chapter 5 in the book, Microsoft SQL Server 2012 Integration Services.

For information on installing Team Foundation Server, see Installing Team Foundation Server

To connect to Visual Studio Team Foundation Server 2012

  1. Launch SQL Server Data Tools (SSDT).

  2. On the Team menu, click Connect to Team Foundation Server.

  3. In the Team Explorer – Connect pane, click Connect.

  4. In the Connect to Team Foundation Server dialog box, click Servers.

  5. In the Add/Remove Team Foundation Server dialog box, click Add.

  6. In the Add Team Foundation Server dialog box, enter the server information, click OK, and then click Close in the Add/Remove Team Foundation Server dialog box.

  7. In the Connect to Team Project dialog box, select the server you’ve added, click the appropriate team project, and then click Connect.

To add an Integration Services project to Visual Studio Team Foundation Server 2012

  1. On the Team menu in SQL Server Data Tools (SSDT), click Connect to Team Foundation Server.

  2. In Solution Explorer, right-click the project and then clickAdd Solution to Source Control.

  3. Click a folder in the Team Project Location area, or click Make New Folder and select the new folder, and then click OK.

To check an Integration Services project into Visual Studio Team Foundation Server 2012

  1. In Solution Explorer in SQL Server Data Tools (SSDT), right-click the project and then click Check In. The Team Explorer pane appears.

  2. (Optionally) Under Included Changes, click Exclude All. Or, under Excluded Changes, click Include All.

  3. (Optionally) Under Notes, you can add comments for the code reviewer, security reviewer, and the performance reviewer.

  4. Enter a comment in the Comment box, and then click Check In.

See Also

Other Resources

Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012 (Download)

Thoughts on Branching Strategies for SSIS Projects

Team Development with TFS Guide