How to load XML File into sql server db through DTS ?
Pls let me know.

Thanks

Hi,
I suggest You to use SQLXML 3.0 Data Access Components.
You can download it from MS WebSite:
http://www.microsoft.com/downloads/t...displaylang=en
You can use SQLXMLBulkLoad obj. to load data from XML source to MS SQL 2000
database.
The example is set below.
Rgds,
Kornel.

Function Main()
Dim objXBulkLoad
Set objXBulkLoad = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad.3.0")
objXBulkLoad.ConnectionString = "provider=SQLOLEDB.1;server=(local);" & _
"database=test;Trusted_Connection=Yes;"
objXBulkLoad.Execute "c:\my_schema.xsd", "c:\my_data.xml"
Main = DTSTaskExecResult_Success
End Function


U¿ytkownik "mvp" <mvp (AT) discussions (DOT) microsoft.com> napisa³ w wiadomo¶ci
news:6D80EF86-C059-4362-818E-B4599565A606 (AT) microsoft (DOT) com...