I am trying to perfom a bulk load of XML to sql in ASP.Net and stuck on a problem for some time now
The method I believe I should use is SQLXMLBULKLOAD as defined in http://support.microsoft.com/kb/316005
as this will allow me to map attributes and elements in the XML data to the SQL table using a mapping table.
To do this I need to import Interop.XBulkLoad4 and get xblkld4.dll into the bin directory. However XBulkLoad4 cannot be loaded & I can't seem to load the dll.
How can I get SQLXMLBULKLOAD to work in Visual studio express I have SQL server 2008 installed.
assistance would be much appreciated