Sadly, out of the box, you can’t connect from BIDS 2008 (the SQL 2008 or 2008 R2 version) to TFS 2010. I guess this will come with Denali where hopefully the new Juneau Development Environment will be integrated with TFS 2010.
I managed to get SQL Server 2008 R2 BI development tools (BIDS 2008) to work with TFS 2010 by doing the following:
1. Install BI Development Tools that come with SQL Server 2008 R2
2. Install VS2008 Team Explorer (for BIDS/VS2008 from MSFT available here)
3. Install VS2008 Service Pack 1 (available here)
4. Install VS2008 SP1 Forward Compatibility Update for TFS 2010 (available here)
Once I had done that, I was able to connect to a TFS 2010 Project and successfully check VS2008 projects in and out of source control, raise bugs etc.
Have attached a few screen grabs showing the integration from BIDS and also from the Web Client Portal (basically Sharepoint for TFS) showing some of the out of the box dashboard stuff.
Note that when entering a TFS server to connect to in BIDS, a change from TFS 2008 means that you now need to fully qualify your TFS Project
When asked for which TFS Server to connect to, type http://VM2008BITFS:8080/TFS (assuming you use default ports etc)
Team Web Access in TFS 2010
Portal Dashboard in TFS 2010
BIDS check-in & source control access (similar to TFS 2008)