SQLXMLBULKLOAD in Visual Studio express
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
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
ASKER
I have downloaded Microsoft SQLXML 4.0 SP1 howeverthis does not get SQLXMLBULKLOAD to work nor recognise either "Imports SQLXMLBULKLOADLib" or "Imports Interop.XBulkLoad4".
From reading other comments I will need to get xblkld4.dll placed in the bin directory. This can apparently be done by using tlbimp.exe. I have searched all folders and cannot find the location of tlbimp.exe.
Could you assist further to get SQLXMLBULKLOAD to work.
kind regards
From reading other comments I will need to get xblkld4.dll placed in the bin directory. This can apparently be done by using tlbimp.exe. I have searched all folders and cannot find the location of tlbimp.exe.
Could you assist further to get SQLXMLBULKLOAD to work.
kind regards
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Very useful many thanks
http://www.microsoft.com/downloads/details.aspx?FamilyId=228DE03F-3B5A-428A-923F-58A033D316E1&displaylang=en
Go down the page until you see "Microsoft SQLXML 4.0 SP1". Download the package that applies for you and install it properly.
It says here: http://msdn.microsoft.com/en-us/library/ms171744.aspx
that is not installed by default with SQL 2008 Express.