Still using Visual Studio 6 and wishing you had an integrated Team Foundation Version Control experience? Now you can! As noted below, the Team Foundation Server MSSCCI Provider is now available for download. You should note that this version is intended for use with Team Foundation Server Beta 3 Refresh. They'll be updating this with a version that works with the Team Foundation Server Release Candidate (RC) when it ships early next year.
The Visual Studio Team Foundation Server MSSCCI Provider enables users of Visual Studio 6.0 to use Visual Studio 2005 Team Foundation Server Version Control with integrated source control features.
Download details: Visual Studio Team Foundation Server MSSCCI Provider.
For more information, see this post in Brian Harry's blog.