How many of you are using Visual Studio 2010? How many of you are writing SSIS packages? How many of you are pissed off, irritated, or confused about how you’ll be able to write and version control your SSIS packages (VS 2008) once you’ve upgraded to TFS 2010?
Confused yet? Yeah, so am I.
Let’s backtrack: at work we recently upgraded to VS 2010 and TFS 2010 – this lets everyone on my team take advantage of the database developer edition as well as add a whole slew of automated testing features and doodads. Plus our management can tie in to our tasks
One of the problems that we ran into is connecting to TFS2010 from VS2008. Why would I need to do that? Visual Studio 2010 doesn’t have support for the SQL Server 2008 BI project types yet (SSRS, SSIS, etc). So, in order to work on SSIS packages, I need to keep VS 2008 around.
It’s pretty easy to connect Visual Studio 2008 to TFS 2010. Download this hotfix, install it, and then you’re up and running. That’s really all there is to it.
Comments
I think you are missing 2 other necessary pieces you’d have to install along with the Forward Compatibility Update (FCU) you mentioned.
The first and most basic thing is that you’d need a VS 2008 Team Explorer (TE) plug-in unless you already inherited this as part of VSTS. Since a lot of folks have different/lower versions of VS (not VSTS), it is mandatory that TE is installed separately. Plus, you’d have to install VS 2008 SP1 after you install VS 2008 TE. Without this the TE you just installed won’t work. Install the VS SP1 even if you already had it installed. That’s how Microsoft wants us to do (yes, it’s lame)!
After installing TE and SP1 (in that order), you should then install the FCU. Keep in mind that this order matters a lot.
Btw, if you are using VS 2005, the exact same guidelines apply:
1. Install VS 2005 TE
2. Install VS 2005 SP1
3. Install VS 2005 FCU (for TFS 2010)
If you need to connect to TFS 2010 from SSMS 2005/2008 download the specific Microsoft provided MSSCI providers. You can find this easily with a Google search.
Thanks for adding the extra information.