Subject:Unable to Bulk Load the XML file to SQL Server 2000 Author:Rama Kadiyala Date:19 Jun 2006 09:05 AM
Hello All,
I am new to the XML World. What I am trying to do is to load a XML Data file from the xsd file provided to me to SQL SERVER 2000 file. Is there any way for me in Stylus Studio to create a new xsd file from an existing XML file. Any help is greatly appreciated.
Subject:Unable to Bulk Load the XML file to SQL Server 2000 Author:Rama Kadiyala Date:19 Jun 2006 11:18 AM
Ivan,
Thanks. That helped a lot, It created a Prod_stylus.xsd from the XML Document. How can I load the XML Data into SQL SERVER 2000?
Can I do it in Stylus?
Subject:Unable to Bulk Load the XML file to SQL Server 2000 Author:Rama Kadiyala Date:19 Jun 2006 11:34 AM
Also I am getting the following errors when I validate the converted XSD document:
-----
Validating prod_samlple_1.xsd...
file:///i:/bh_prod_xml/Script_dev/xsi.xsd:4,68: The {target namespace} of 'noNamespaceSchemaLocation' must not match 'http://www.w3.org/2001/XMLSchema-instance'.
file:///i:/bh_prod_xml/Script_dev/xsi.xsd:5,30: The {target namespace} of 'type' must not match 'http://www.w3.org/2001/XMLSchema-instance'.
file:///i:/bh_prod_xml/Script_dev/prod_samlple_1.xsd:32,56: Could not find top level attribute: xsi:type
file:///i:/bh_prod_xml/Script_dev/prod_samlple_1.xsd:9,73: Could not find top level attribute: xsi:noNamespaceSchemaLocation
The XML document prod_samlple_1.xsd is NOT valid (4 errors)
--------------
Stylus Studio doesn't provide an automatic way to create the mapping file, but you can still use the XML editor in conjution with the File Explorer to browse which table/columns you wish to map.