Project wants to check out .dtproj in SSIS project every time TFS Get Latest is performed

Question

Using Team Foundation server and BIDS 2008, I receive a screen to check out the dtproj file every time the Get Latest operation is performed.

Steps to Produce: I have no files checked out after performing a "Get Latest" from solution explorer. I click to open the solution file .sln from Solution Explorer and the SSIS project opens. I then receive a "Check Out" screen asking me to Check Out the .dtproj file.

Any ideas how to keep this from happening?

This happens for us all the time as well. It has to do with multiple users using SSIS 2005/2008 solution under TFS, and seems to have to do with everyone having a slightly different database file name in each project. One person checks in ... others get latest and it checks it out for them. I don't know of any workarounds. — Korey, Feb 28 '12 at 22:04

score 0 · Answer 1 · answered May 27 '14 at 21:22

0

This behavior appears to stop if you manually add the .database file to TFS through Source Control Explorer, making sure that the .database filename inside the .dtproj is the same name as the file you add to TFS.

answered May 27 '14 at 21:22

Thomas F. Abraham

2,082
1
19
24

score 0 · Answer 2 · answered Nov 27 '14 at 00:43

Turns out the .database file is a local 'runtime' type file that Visual Studio creates each time. It is not an actual source file and should not be checked into source safe. What I think happens is that:

This file gets created by VS
At some point someone checks it into source safe, making the file read only in their working folder
Next time VS tries to create the file again. It can't (unless it's checked out) so it creates another one with a slightly different name
Because the filename is now different is changes the .dtproj file that references it. It therefore tries to check the .dtproj file out because a change has automatically been made to it
Chaos and confusion ensues

This is roughly what we did to fix this:

Delete any .database files from source control, ensure that it never gets added back again
Close VS
Backup and delete any .database files from local dev folder
Open VS and get latest
You might get 'this project couldn't be loaded' type errors in VS because the referenced .database file is missing
To get the project loaded, you need to get a valid .database file (these can get corrupted - check the file contents) into your local folder, and edit the .dtproj file in a text editor to point at the valid file
Once you have your .dtproj file working, check it in and have everyone get latest
Make sure no one ever checks in the .database file

Why oh why is it called a .database file when it has nothing to do with a database. When you search online for .database you get...... information about databases, not this annoying VS file.

score 0 · Answer 3 · edited May 23 '17 at 10:32

I have been using BIDS 2008 with TFS 2010 for quite sometime but never had the issue that you are facing. Here are the Source Control settings on my BIDS environment.

Some of the other links that might help you:

A project is automatic check outs everytime when i opens the solution in TFS 2008

How to stop Visual Studio from "always" checking out solution files?

Plug-in Selection