Using TFS2010 with Visual Studio / BIDS 2008 and SQL Server Management Studio

When I come to a customer site, I often have to help them get setup with TFS (Team Foundation Server) 2010, Microsoft’s source code control / ALM (application lifecycle management) system. This is so they can work with their BIDS (Business Intelligence Developer Studio) projects as a team, giving the added benefit of source code control. I’ve had to do this often enough I wanted to record the steps for my own use, and hopefully others too.

Installing the TFS 2010 tools for Visual Studio / BIDS 2008

First off, thanks to Derek Miller for covering most of the steps involved in his blog post http://derekjmiller62.wordpress.com/2010/10/19/using-tfs-2010-with-bids-2008/. I won’t go into the detail he did, but will summarize into these basic steps.

1. If you haven’t installed Visual Studio 2008 Service Pack 1, do so by downloading it and installing.

2. Next, you will need to install the Visual Studio 2008 Team Explorer.

3. After installing Team Explorer, you will have to go back and reinstall VS SP1 (from step 1). Don’t skip this step! Team explorer has some older components that overwrite the SP1 components, and you will have reinstall them.

Now this next part I really haven’t seen anywhere else and was a real pain to find, and thus is the main reason for this post. During the SP1 install, we often see “Visual Studio SP1 Installation Failed”. Checking the error log, buried deep you will find “Returning IDOK. INSTALLMESSAGE_ERROR [Error 2902. An internal error has occurred. …”

When you see this, go to your Control Panel, and then to Add Remove Programs. Look for a program called “Microsoft Visual Studio Web Authoring Component” and uninstall it. This is actually installed as part of the Office suite, and you don’t really need it since you likely have much more powerful web authoring tools, or since you are doing BI development won’t be doing an web development in Microsoft Office.

After uninstalling it, SP1 should then install, and you are ready for step 4.

4. Install the Visual Studio Team System 2008 SP1 Forward Compatibility Update for Team Foundation Server 2010. That probably took you longer to read than it actually will to install. After installing, it may prompt you to reboot. Even if it doesn’t ask you should reboot anyway, we’ve seen a few times when we weren’t able to connect until we rebooted.

After that you should be able to go into Visual Studio and go to Tools, Connect to Team Foundation Server. If you still have problems connecting, I will refer you to Derek’s post where he describes some registry entries you can try. So far we haven’t found them necessary, but you may.

Installing the TFS 2010 Tools

Note that there is one big limitation to using TFS 2010 with VS2008. You can connect to a TFS site and upload your solutions and projects, but you can’t create a new team site with VS2008. To do so, you will need the VS2010 shell with the TFS components, a free download.

Installing TFS 2010 for SQL Server Management Studio (SSMS)

Now that you have BIDS all setup to work with TFS, it only makes sense to make your SQL Server Management Studio (SSMS) also work with TFS. Joseph Jun has a great blog post that goes into all the nitty gritty of how to do this. The short version though, is after you install the TFS 2010 tools in the step above (and they are a prerequisite) you need to install the Team Foundation Server MSSCCI Provider 2010.

After the install, you should see a new Source Control menu option under the File menu in SSMS. From here you can launch the TFS 2010 management shell or open an existing SSMS project / solution. If you have a solution you need to add, simply right click on the solution in the Solution Explorer window and pick Add to Source Control.

Visual Studio Database Projects

Note that if you are using Visual Studio Database Projects, any SQL Server 2008R2 development must be done in Visual Studio 2010. VS2010 is already setup to talk to TFS 2010. If you are using VS 2008 database projects to build a SQL Server 2008 (non-R2) database, then with the steps above you should be good to go for checking in your database project into TFS.

And away we go!

And with that you should be setup to manage your BI Development in Team Foundation Server 2010. It’s a lot of work, but well worth the effort. Using TFS will let your BI staff work as a team to develop projects. Additionally you have the benefit of source code control, something invaluable in the case of package corruptions or needing to track history.

About these ads

7 Responses to “Using TFS2010 with Visual Studio / BIDS 2008 and SQL Server Management Studio”

  1. Technical Marketing Consultant, 2008-2010, SQLink, Tel Aviv | Resume Wim Vincken Says:

    [...] Using TFS2010 with Visual Studio / BIDS 2008 and SQL Server Management Studio (arcanecode.com) Share on bebo Bookmark on Delicious Digg this post Recommend on Facebook Tip on Hyves Share on Linkedin Mixx it up Share via MySpace share via Reddit Share with Stumblers Share on technorati Tumblr it Tweet about it Share on xing Subscribe to the comments on this post Print for later Bookmark in Browser Tell a friend Tags: BusinessContent managementDNNDotNetNukeInternet marketingMarketingMicrosoft SQL ServerMicrosoft Visual StudioSearch engine optimizationSQL Server 2008Uniform Resource LocatorWebsite /* [...]

  2. namanami Says:

    Did you experience any problem when doing this on Windows7? The last upgrade you mention is erroring me it is incompatible with windows 7 32 bits.
    Thanks

    • namanami Says:

      I got my error- the file I downloaded was somehow corrupted. I redownloaded it and now it upgraded fine. Thanks anyway.

  3. ob213 Says:

    Installing TFS 2010 for SQL Server Management Studio (SSMS) 2012

    First, I installed the TFS 2010 tools in the step above (and they are a prerequisite) Then I installed the Team Foundation Server MSSCCI Provider 2010.

    After the installs, I only see an old VSS 6 Source Control menu option under the File menu in SSMS. I can’t launch the TFS 2010 management shell. If I right click on the solution in the Solution Explorer window and pick Add to Source Control, it goes to VSS 6.

  4. kevin Says:

    Where can I find – Visual Studio Team System 2008 Service Pack 1 Forward Compatibility Update for Team Foundation Server 2012

  5. Vaughan Says:

    Have you encountered a way to use the TFS build functionality to automatically build and deploy SSIS packages to servers?


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 102 other followers

%d bloggers like this: