Loading SQL Server table from XML file

[mac4_life]

Hello,
I am doing a little research... What would be the easiest way to load a SQL Server table from an external XML file? Can I load it as one blob or do I have to pull it into a datatable?

Thanks for your help!

 

[TechGnome]

Well, that depends.... do you want it all parsed out and the different elements into individual fields? Or do you just want the entire XML file right into one field in the DB?

-tg

 

[mac4_life]

I would like them parsed and into the same field names on SQL server as they are in XML.

 

[TechGnome]

Then a blob isn't going to work (blobs are used for storing binary data or realy large text items.) since you want the data parced. You best bet will be to load it up into a dataset, then run through that and insert the data into the database where it goes.

-tg

 

[jmcilhinney]

Moved to more appropriate forum.