Using XML as source
I want to use an XML as source but the destination would be 3 different SQL
tables. How do I do it?
Re: Using XML as source
Depending on the size and shape, availability of an XML Schema and where you
want to run business logic:
1. use the ADO.Net dataset mapping of the XML.
2. use the SQL XML Bulkload object with annotated schema
3. write a stored procedure in TSQL using an XML parameter and the nodes()
See Books online for more details or the archives of this newsgroup.
"Jnanesh Naik" wrote in message
> I want to use an XML as source but the destination would be 3 different
> SQL tables. How do I do it?