Search code examples
ssisvisual-sourcesafe

Get SSIS solution from VSS


I have very little idea on SSIS and controlling this using VSS (Visual Source Safe). I have a requirement in my project to go through a few SSIS solutions/Projects. Can someone please help me how can I access this and view as a proper setup. Below is the rough structure of the VSS

Project1

-Project1 : has file.sql, Project1.sln, Project1.vssscc (please help me understand this)

-dbBuild : has db_build.dbp, db_build dbp.vspscc

-dbStaging

and so on.


Solution

  • I would open VSS and navigate to the Project folder. Then I would right-click the Project folder and choose Get Latest Version.

    You will be prompted to set the Working folder - I normally create a new folder on the Dev machine's hard drive e.g. C:\Dev\MyProject. I would check the options for Recursive and then Build tree.

    This will effectively create a copy of the latest VSS content in the hard drive folder, which you can then open using Visual Studio.