MS SQL Server Tools - SQLXMLBulkLoad namespace problems

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SQLXMLBulkLoad namespace problems

Christopher

2006-03-24, 9:31 am

I have problems using namespaces when using SQLXMLBulkLoad

Starting from the example

http://msdn2.microsoft.com/en-us/library/ms171806.aspx part D. Bulk loading
in identity type columns

If the xml should be changed to

<ROOT xmlns="http://tempuri.org/schema.xsd" >
<Order OrderID="11" CustomerID="ALFKI">
<Product ProductID="11" ProductName="Chai" />
<Product ProductID="22" ProductName="Chang" />
</Order>
<Order OrderID="22" CustomerID="ANATR">
<Product ProductID="33" ProductName="Aniseed Syrup" />
<Product ProductID="44" ProductName="Gumbo Mix" />
</Order>
</ROOT>

What would be done to the schema to make it work?

Any ideas?

--
Christopher Schmidt
Rehfeld A/S

Sponsored Links