We don’t have any good source control for our Microsoft BI projects.Business intelligence development studio 2005 and 2008 does not compatible with Team foundation server for maintaining the source control. If you have installed the Team explorer 2008 in our machine and try to connect to the TFS 2010 server. You can add the project server, but we could not connect to the project collection.
We can incorporate BIDS 2008 into TFS and Maintain the source control. You can use the steps from following link from David Elish’s blog
http://sqlserverselect.blogspot.in/2011/12/bids-visual-studio-2008-shell-with-tfs.html
I have followed the above steps and configured our BI projects. Please take look at the following screenshot. We have created the project collection called the “BIVersion” and added three BI projects [SSISDemo, SSRSDemo and SSASDemo].
Did you integrate your project BI project into the TFS?
Thanks,
Gowdhaman
