Hi Folks, I have a large XML file (350mb) , I need to import the XML file into SQL. I believe my options are either bulk loading the file into a table and XML field or using OPENXML. The problem that I have with the bulk load is that I then need to use XQuery to return the desired results (I know very little about XQuery or XPath) and I want to import the file in the sameway an access datafile imports an XML file i.e creating tables and importing data for parents and child nodes. Im not sure what method to use and any advice would be appreciated
Our community of experts have been thoroughly vetted for their expertise and industry experience.