Also beware that in SQL Server 2008 the SQLXML component is no longer supplied.

Refer to http://msdn.microsoft.com/en-us/library/ms171744.aspx for download instructions.

Wasted 2 days getting a very simple VBScript to run!