I need to bulk load XML documents into SQL Server 2000. I've written a XSD and everything is working fine except when I have repetitive elements. If the elements are complex and maps into a table I can take care of it with the maxOccurs="unbounded" statement. But how do I do if I have several single elements that will map into a single column in a table? Is it even possible?
thank you, Helena