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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Mapping tool for using XML Bulk load

Author  Topic 

Vishakha
Starting Member

40 Posts

Posted - 2007-01-11 : 23:09:04
We are planning to use SQLServer XMLBulkLoad for importing data into our system

We have data in xml, would like to know if there are any tools available that can create a mapping file and corresponding tables in the database.

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-01-11 : 23:32:49
have a look at the the SchemaGen property on the SQLXMLBulkLoad class:

http://msdn2.microsoft.com/en-us/library/ms171769.aspx


www.elsasoft.org
Go to Top of Page

Vishakha
Starting Member

40 Posts

Posted - 2007-01-11 : 23:52:10
This will only create the schema from the mapping file, which is good, but what I am really interested in is given an XML file, can a tool create Mapping file.

Go to Top of Page
   

- Advertisement -