hello all,
hope this is the right place to post this question.
My problem is that I cannot import xml files using bulkload .
The Give error shown
An unhandled exception of type
'System.Runtime.InteropServices.COMException' occurred in Unknown Module.
Additional information: Error connecting to the data source.
I put a star in following code at that place .Error will be shown.
Private Sub BulkLoadXML()
Dim bulkload As New Thread(New ThreadStart(AddressOf
ExecuteBulkCall))
bulkload.ApartmentState = ApartmentState.STA
bulkload.Start()
bulkload.Join()
End Sub
Private Sub ExecuteBulkCall()
Dim _bulkInstance As New SQLXMLBulkLoad3Class
_bulkInstance.ConnectionString = UTGlobals.ConnectionString
_bulkInstance.ErrorLogFile = "c:\temp\xmlerror.log"
_bulkInstance.KeepIdentity = False
***** _bulkInstance.Execute("c:\XMLfile1.xsd", "c:\XMLfile1.xml")
End Sub
so,Any body know that please mail to me,
Regards,
Arulraja
--
Message posted via http://www.dotnetmonster.com