My continous integration environment is coming along nicely. I currently have five projects integrated...3 web sites, 1 VB Outlook Addin Application and 1 Compact Frameworks Application. The most advanced project I have in place is a web site that uses the following script:

To summarize:
- First the Team Foundation Server source control repository is checked to see if any files are updated.
- If files are updated, then CruiseControl automatically gets all the files from the source control repository.
- MSBuild kicks off and builds the class libraries and web site.
- NUnit tests are ran against the class library
- MSBuild kicks off a Web Deployment Project to update the staging server and change the connection string keys in the web.config file.
- Last but not least functional test are kicked off through a NUnit test that executes WATIR test scripts
This is working excellent!