writing XML documents to databases

[GreggyBoy]

Warning: very simple & high level question from a complete XML novice

Organization I work for needs to integrate data from several remote databases into a central MIS system. I can see there are several ways of extractying the data into a Document.

Inserting however has validation and type conversion "challenges".

Is there a particularly good/reliable/straightforward approach ?
(eg, reading the document in VB/C# and checking for NULLs etc etc and then inserting or not, or using SQL Server T-SQL, or other methods) ???

Thanks for any of your views.

 

[JontyMC]

XML Schema:

http://www.w3schools.com/schema/default.asp

Jon

"I don't regret this, but I both rue and lament it.