If you're trying to load XML from an existing file - its not that easy, I've been researching it online lately. The clearest article I found on it was:
http://www.builderau.com.au/program/sqlserver/soa/Reading_an_XML_file_from_SQL_Server/0,39028455,39174685,00.htm
but I...