Best method of importing XML data into SQL 2008

Have you tried this:
http://msdn.microsoft.com/en-us/library/ms171993.aspx
or for 2005:
http://msdn.microsoft.com/en-us/library/ms171993(SQL.90).aspx

problem is that im using SQL Express, I think using Xquery Nodes is the best option that Iv found so far

>>I believe my options are either bulk loading the file into a table and XML field or using OPENXML.
...
I think using Xquery Nodes is the best option that Iv found so far <<
You are talking about two different methods: OPENXML or XML Data Type Methods.

While OPENXML is fast with small files, you may find that with a file oif that size it may croak.  I have never tried to use OPENXML with an Xml document that big.

The other problem you have is that it sounds like you want to import this Xml document into more than one table and therefore more complex. So unless you have the expertise you may want to hire a consultant to help you on this project.

yes I understand that they are two differnet methods and was asking what method would be best for a file that size and complex, the bigger problem i have is that the XML file is not well formed  and while I was trying to use TSQL and xquery to resolve the problem so I could run a stored procedure, the best solution appears to be using the SQLXML in a vbscript of asp.net file.

>>was asking what method would be best for a file that size and complex<<
Right and I believe I answered that question.

>> the bigger problem i have is that the XML file is not well formed<<
Than you cannot use any SQL Server Xml method, be it OPENXML, Xml Data Type Method or SQLXML for that matter.  If the Xml file is not well-formed, than it is not an Xml document that SQL can consume as Xml.