A lot of my clients are still working with SSIS 2008 (R2), but already have Team Foundation Server 2010 for source control. How can you connect to TFS 2010 with BIDS/Visual Studio 2008?
Solution
Although this blog is about SSIS, this solution works for all kinds of Visual Studio 2008 projects.
1) Install Team Explorer
First you need to install "Visual Studio Team System 2008 Team Explorer" which is a simplified Visual Studio Team System 2008 environment used solely to access Team Foundation Server services. You can download it here.
 |
| Next, Next, Finish |
2) Install VS 2008 SP1
Secondly install "Microsoft Visual Studio 2008 Service Pack 1" (even if it was already installed before step 1). You can download it here.
 |
| Next, Next, Finish |
3) Install Team System 2008 SP1
Thirdly install "Visual Studio Team System 2008 Service Pack 1 Forward Compatibility Update for Team Foundation Server 2010", which you can download here. This Service Pack let's you connect to TFS 2010.
 |
| Next, Next, Finish |
4) Connect to Team Foundation Server in BIDS.
a) In the Tools menu click "Connect to Team Foundation Server"
 |
| Connect to Team Foundation Server |
b) In the next screen click on "Servers..."
 |
| Connect to Team Foundation Server, Servers... |
c) And in the next screen click on "Add..."
 |
| Connect to Team Foundation Server, Servers..., Add... |
d) If you connect over http then your url should look something like this (don't use port number and protocol):
 |
| Connect to Team Foundation Server over http |
And if you connect over https then you url should look something like this (don't use port number and protocol):
 |
| Connect to Team Foundation Server over https |
Note: If you get this error "TF30335: The server name cannot contain the characters '/' or ':', or start with 'http://' or 'https://'. If the server name is an IPv6 address, it can contain the character ':' only if the full name is enclosed by square brackets.", while trying to connect to Team Foundation Server 2010 then you probably forgot the third step of this post.
 |
| Team Foundation Server 2010 |
e) Click "OK" to add the server. Depending on the environment/tfs settings you now have to enter your username and password. After this step your tfs server will be added to Visual Studio/BIDS. Select it and click "Close"
 |
| Connect to Team Foundation Server, Servers..., Close |
f) Now you can select one or more projects.
 |
| Available TFS projects |
g) And they are also available via the Team Explorer / Source Control Explorer so you can open an existing SSIS project.
 |
| Team Explorer / Source Control Explorer |
Or you can add a new SSIS project to source control.
Note: Disable multiple check-out!