I just finished setting up an CI with TFS in da cloud (tfs.visualstudio.com) with auto-publish to my team's web host. Pheeew!
Well, the first part was quite easy. Setting up a TFS is easy as pie. Just go to http://tfs.visualstudio.com/ and setup your account. I choose Git as version control. There was an easy guide to send your repo to your TFS server. Then there was a good guide to set up a build. But, then the tricky part came when I was going to set up a web deploy to the web host.
The web host is Arvixe and they have a pretty desent hosting environment. To allow Web Deployment you just go to the site's configuration and to the tab "Publishing" and enable. Then you can download the publish profile and import it in Visual Studio 2012. But to make the publishing successful you have to tell the publishing operation to not touch the folder and files permissions. Since you are in a hosting environment you are not admin and are not allowed to do so. This is easy as pie. Follow these instructions from this website: