I have a selection of about 1000 xml files in my website, which contain product data.
I am using a combination of [url removed, login to view](vb) using the XmlDocument() object? to read and insert into MS SQL 2008 using a stored procedure.
The page works fine for most of the files, I have some exceptions, several of the xml files are large, nearly 1gb in size each, I am receiving the error [url removed, login to view] due to the XmlDocument() object being unable to read files of this size.
I either need someone to help rework my code which can be provided to the successful bidder or someone to re-create the routine for me.
I'm looking for a simple routine that I can simply pass a filename to, the routine will then extract the relevant nodes and insert into my MS SQL2008 database.