Posts Tagged ‘TFS and BIDS’

Using BIDS 2008 with TFS 2010


If you are working on BI projects and use Microsoft Business Intelligence Development Studio 2008 (BIDS\Visual Studio 2008) for SSIS, SSRS and SSAS and one fine day your application development team has decided to move on to Visual Studio 2010 and Team Foundation Server 2012 you might think initially that there was either a BIDS 2010 version out there that was released with Visual Studio 2010. If you are a SQL junkie you know better that you have to wait until SQL Server 2012. To be clear – You *can* host your current BIDS 2008 projects in TFS 2012, but unless you install the following components you will not be able to use Team Explorer for your BIDS projects, nor can source control actions (check-ins, check-outs etc.) be performed from the IDE. Without the additional components a BI developer is stuck to developing in BIDS 2008 and then make sure (as a separate task, post development) to regularly integrate code artifacts with TFS. Sure does sound painful, but lets make it easy on us.


The fix consists of installing Visual Studio 2008 Team explorer and the forward compatibility update for connecting to Team Foundation Server 2010 from Visual Studio 2008.

Installation steps:

1. Close any open instances of Visual Studio 2008 and Visual Studio 2010 before installation.

2. Download and Install VS 2008 Team Explorer using the following URL.

3. Install VS 2008 Service Pack 1: Download and install the following service pack

4. Install the Visual Studio Team System 2008 Service Pack 1 Forward Compatibility Update for Team Foundation Server 2010 (VS90SP1-KB974558-x86.exe)

5. Open Business Intelligence Development Studio (Start\Programs\Microsoft SQL Server 2008 R2\ SQL Server Business Intelligence Development Studio)

  • Select “Tools” –> “Connect to Team Foundation Server”


  • Click “Servers” –> “Add” to connect to TFS 2012.

Note: Open the Visual Studio 2008\BIDS 2008 project from a Visual Studio 2008 solution *only*. If you open Visual Studio 2010 (using Team Explorer) and try to open the VS 2008\BIDS project from that  location it will corrupt your BIDS solution as VS 2010 will try to convert it\upgrade your 2008 solution to 2010. Make sure all the developers are aware of this and they don’t inadvertently upgrade the solution.

If all steps above finish smoothly, you are all set. Just make sure of the note above.


It certainly would have been nice if an upgrade to BIDS 2008 was provided when the VS 2010 release came along. All these tweaks would be avoided and the solutions could be managed cleanly. I take this as a small setback and not a major one. Because, in an agile environment where all the projects are set up with CI build and deploys, one could successfully manage VS 2010 projects (ex: Database Projects) and VS 2008 projects (ex: SSIS, SSRS projects) in tandem. The build configuration for BIDS 2008 projects will have to be performed as a custom build step as this would be another place where the build process in TFS 2012 may not support the older versions on Visual Studio. But still both projects versions are deployed under one build workflow. Hope this walkthrough was helpful.