Hello all. I have a large XML file that I need to load into my database. I built the database structure using the matching XSD file. I have tried SQLXMLBULKLOADLib but ran into some problems, so now I'm looking for other options.

I can successfully load the XML document into a DataSet. This results in 237 tables in the DataSet. I want to push the data from the DataSet into the SQL Server tables. How can I accomplish this in code? Thanks.

Code thus far:

DataSet ds = new DataSet();
FileStream fs = new FileStream(@"C:\temp\test.xml", FileMode.Open, FileAccess.Read);
ds.ReadXml(fs);
fs.Close();
//Do something here to insert rows from DataSet into SQL Server