This is an article that I wanted to write long time ago and finally I have written it today. Somehow I am quited fascinated with SCC providers since many years ago and this question has appeared several times in the forums:

HOWTO: Interact with a source code control (SCC) provider from a Visual Studio add-in
http://www.mztools.com/articles/2007/MZ013.htm