SQLXMLBulkLoad namespace problems

microsoft.public.sqlserver.tools

24 Mar 2006 2:50 PM

Christopher

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