EDN Admin
Well-known member
Hi,
I am struggling to use XML Bulk Load to import an XML file into a single SQL Server table. I have a quite complicated XSD generated by Visual Studio, and SQLXMLBulkLoad wants me to create relationships between child and parent tables....however I only have
one SQL Server table.
All I want to do is map every element and attribute in my XML to a single column in my one table.
I was wondering if anybody had any ideas for other ways of doing this, or, perhaps I could use XSLT in some way?
Vert grateful for any thoughts,
Martin
View the full article
I am struggling to use XML Bulk Load to import an XML file into a single SQL Server table. I have a quite complicated XSD generated by Visual Studio, and SQLXMLBulkLoad wants me to create relationships between child and parent tables....however I only have
one SQL Server table.
All I want to do is map every element and attribute in my XML to a single column in my one table.
I was wondering if anybody had any ideas for other ways of doing this, or, perhaps I could use XSLT in some way?
Vert grateful for any thoughts,
Martin
View the full article