One of my clients has a web application that automates updating their clients sites with the latest ASP pages, DLL, and SQL scripts on their databases. This week the idea came up of having that web application grab the latest version of the appropriate ASP pages from SourceSafe during this automation process. We figured it could be done, since Visual Studio can automate SourceSafe, and it also wouldn't be like Microsoft to not make that sort of thing automatable. Below are two links to documentation and example code.
VSS 6.0 Automation Documentation: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvss/html/vssauto.asp
VB and VB.NET Examples: http://msdn.microsoft.com/vstudio/previous/ssafe/downloads/samples/
You are all probably thinking, Is 'Automatable' really a word? According to Dictionary.com it is: http://dictionary.reference.com/search?q=automatable