*snip*
>p.s. Have you ever used automation with VSS? - I'm thinking maybe it would integrate with a project hook.

No, I haven't, yet. But yes, you should be able to access VSS thru project hooks. A how-to document is at the website: msdn.microsoft.com/ssafe (How to Write Automation for Visual SourceSafe)