September 18, 2009 at 4:56 am
Hi
I have an SSIS project developed in Visual Studio 2008 which is stored in TFS. Packages are being added by a team of 5+ people from different systems.
When adding packages, we have to check in the project file(.dtproject) as well for it to be viewable in the project. So this inevitably will lead to conflicts in the dtproject file. So we use the merge tool in TFS to resolve it. And it works without any serious issues(Visual Studio does crash at time giving a memory corrupted error, but re-opening Visual studio solves it)
While checking in, a "vspscc" file(eg: ETL_Trans.dtproj.vspscc) is also ticked automatically. Also when i open the project from source control, it asks if i want the "database" file(eg: ETL_Trans 11.database) to be overwritten.
Since i dont know what is the purpose of these files(googling and binging gives no useful info), i have never checked these in.
So my question is what is the purpose of these 2 files and do i need to check them for any reason?
Till now, not checking them in, has given no problems.
September 18, 2009 at 7:25 am
The .database file contains information that BIDS uses to open the Integration Services project.
Here is some information on the .vspscc (and other source control-related files)
http://alinconstantin.members.winisp.net/webdocs/scc/SccFiles.htm
September 18, 2009 at 7:50 am
wow..that's the first good info i have seen..thanks
But I couldn't figure out if we have to check these in or not. Any ideas?
September 18, 2009 at 8:38 am
I don't think it's necessary. I don't check those files out, I just get the latest version whenever I check a project out of TFS.
None of the files you've mentioned are needed when you create a deployment for your project.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply