Saturday 7 April 2012

SSIS 2008 with Team Foundation Server 2010

Case
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!

7 comments:

  1. UPDATE: As long as you have SP1 to Visual Studio 2008 BIDS;

    This hotfix will bring forward compatability with SSIS 2008 up to Team Foundation 2012 as with tfspreview.com that had me stuck for ages:

    the hotfix:
    http://www.microsoft.com/en-gb/download/details.aspx?id=29983

    ReplyDelete
    Replies
    1. Thanks for the update! Haven't tested it (no TFS 2012 yet). The documentation doesn't mention TFS 2010. Did you test that without all the other updates?

      Delete
  2. It works perfectly for me.. Thank you for sharing this article!!

    ReplyDelete
  3. Thanks for this: looking at TFS 2010 now and this was a great help :)

    ReplyDelete

Please use the SSIS MSDN forum for general SSIS questions that are not about this post. I'm a regular reader of that forum and will gladly answer those questions over there.

All comments are moderated manually to prevent spam.

Related Posts Plugin for WordPress, Blogger...