Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-02-18 : 08:32:37
|
| Mario writes "What I want is to populate 2 tables in Sql Server with the following structures:tblParent (id, lokalname, adresse)tblChild ( id, kategorie, name, referenz)id = primary key in tblParent and foreign key in tblChildThe issue I have is to build XDR schema or XSD schema for this kind of XML file in order to use it later into DTS:Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")objBL.ConnectionString = "provider=SQLOLEDB.1;data source=MARIUS\MARIO;database=auol_restaurant;uid=wwwclient;pwd=www"objBL.ErrorLogFile = "c:\error.log"objBL.Execute "c:\schema.xml", "C:\sample.xml"Set objBL = NothingXML sample file is:<?xml version="1.0" encoding="iso-8859-1"?><toptipp> <lokal> <id>W01973</id> <lokalname>Arkade</lokalname> <!-- restaurant name - vr_Orte -> Name --> <adresse>Yonge 2</adresse> <!-- restaurant address - vr_Addressen -> Street --> <bilder> <bild kategorie="logo" name="Logo" referenz="W01973.jpg"/> <bild kategorie="galerie" name="Galeriebild1" referenz="W01973-001.jpg"/> <bild kategorie="galerie" name="Galeriebild2" referenz="W01973-002.jpg"/> </bilder> </lokal> <lokal> <id>W01974</id> <lokalname>Patria</lokalname> <!-- restaurant name - vr_Orte -> Name --> <adresse>Bathurst 2</adresse> <!-- restaurant address - vr_Addressen -> Street --> <bilder> <bild kategorie="logo" name="Logo" referenz="patria.jpg"/> <bild kategorie="galerie" name="patria1" referenz="patria-001.jpg"/> </bilder> </lokal></toptipp>" |
|
|
|
|
|
Import XML in SQL SERVER with SQLXMLBulkLoad