Please help. i need to create an XSD and dont know how!

hello all.
i attached an xml that need to put data into and sql server tables
i having probleams creating the XSD schema.
i allready have the tables in the sql
i am using the SQLXMLBulkLoad object. and wrote a program with vb.net that
do it.
it's work fine for simple xml and Xsd .
i need help writing the xsd that will insert to data into 2 tables with
relation (that i created )
attached the xml
please help
thanks
<?xml version = '1.0'?>
<ROWSET>
<ROW num="1">
<JOB_NUMBER>3</JOB_NUMBER>
<JOB_TYPE>STANDARD</JOB_TYPE>
<ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>WC E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>10000</ASSEMBLY_QUANTITY>
<CUSTOMER_NUMBER>??? ?????? ?????</CUSTOMER_NUMBER>
<PRODUCTION_LINE>L02</PRODUCTION_LINE>
<BULK_DENSITY>122</BULK_DENSITY>
<PPG>AS33</PPG>
<HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Released</JOB_STATUS>
<LOT_NUMBER>3</LOT_NUMBER>
<COMPONENTS>
<COMPONENTS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>GILADI-510 CHALK</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>1200</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>DOP
DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>3220</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>EDENOL D-82,HENKEL</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>160</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
E2400L</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>50</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
2WH1061</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>100</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>SOLVIN 270PF
SOLVAY</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>5020</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
</COMPONENTS>
<OPERATIONS>
<OPERATIONS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>ELEC02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>2.5</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>SETUP02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>42.999656</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PROD02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>30.0003</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>NONPROD02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>COLORMAT02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>4</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PREMIX02</RESOURCE_CODE>
<REQUIRED_PRODUCTION>4</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
</OPERATIONS>
</ROW>
<ROW num="2">
<JOB_NUMBER>4</JOB_NUMBER>
<JOB_TYPE>PACKING</JOB_TYPE>
<ASSEMBLY_NUMBER>11PVCNZ0004B</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>SOLVIN 270PF SOLVAY</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>100</ASSEMBLY_QUANTITY>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Unreleased</JOB_STATUS>
<COMPONENTS/>
<OPERATIONS/>
</ROW>
<ROW num="3">
<JOB_NUMBER>5</JOB_NUMBER>
<JOB_TYPE>PACKING</JOB_TYPE>
<ASSEMBLY_NUMBER>347200000000</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>P.V.C SOFT 472/NAT.0000</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>100</ASSEMBLY_QUANTITY>
<BULK_DENSITY>44949</BULK_DENSITY>
<PPG>JHY0992</PPG>
<HUMIDITY__PERMITTED>0.998</HUMIDITY__PERMITTED>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Unreleased</JOB_STATUS>
<COMPONENTS/>
<OPERATIONS/>
</ROW>
<ROW num="4">
<JOB_NUMBER>6</JOB_NUMBER>
<JOB_TYPE>STANDARD</JOB_TYPE>
<ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>2</ASSEMBLY_QUANTITY>
<BULK_DENSITY>122</BULK_DENSITY>
<PPG>AS33</PPG>
<HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Released</JOB_STATUS>
<LOT_NUMBER>6</LOT_NUMBER>
<COMPONENTS>
<COMPONENTS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>GILADI-510 CHALK</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.24</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>DOP
DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.644</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>EDENOL D-82,HENKEL</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.032</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
E2400L</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.01</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
2WH1061</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.02</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>SOLVIN 270PF
SOLVAY</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>1.004</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
</COMPONENTS>
<OPERATIONS>
<OPERATIONS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>ELEC04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>7.518797</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>SETUP04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>40</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PROD04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>23.809524</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>NONPROD04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>COLORMAT04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PREMIX04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
</OPERATIONS>
</ROW>
<ROW num="5">
<JOB_NUMBER>7</JOB_NUMBER>
<JOB_TYPE>STANDARD</JOB_TYPE>
<ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>1</ASSEMBLY_QUANTITY>
<BULK_DENSITY>122</BULK_DENSITY>
<PPG>AS33</PPG>
<HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Complete</JOB_STATUS>
<LOT_NUMBER>7</LOT_NUMBER>
<COMPONENTS>
<COMPONENTS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>GILADI-510 CHALK</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.12</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>DOP
DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.322</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>EDENOL D-82,HENKEL</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.016</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
E2400L</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.005</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
2WH1061</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.01</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>SOLVIN 270PF
SOLVAY</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.502</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
<COMPONENTS_ROW num="7">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<DEPARTMENT>PVC</DEPARTMENT>
<COMPONENT_ITEM>14STBLX00034</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>AKROPAN 2143GX
AKDENIZ</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>0.025536</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
</COMPONENTS>
<OPERATIONS>
<OPERATIONS_ROW num="1">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>ELEC04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>7.518797</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="2">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>SETUP04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>40</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="3">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PROD04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>23.809524</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="4">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>NONPROD04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="5">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>COLORMAT04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
<OPERATIONS_ROW num="6">
<OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
<RESOURCE_CODE>PREMIX04</RESOURCE_CODE>
<REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
</OPERATIONS_ROW>
</OPERATIONS>
</ROW>
<ROW num="6">
<JOB_NUMBER>9</JOB_NUMBER>
<JOB_TYPE>PACKING</JOB_TYPE>
<ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
<ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
<ASSEMBLY_QUANTITY>1</ASSEMBLY_QUANTITY>
<CUSTOMER_NUMBER>??? ?????? ?????</CUSTOMER_NUMBER>
<PACK_TYPE>PE BAG WITHOUT LOGO</PACK_TYPE>
<PACK_CODE>PBR</PACK_CODE>
<PALLET_SIZE_TYPE>TELMA PALLET HOLIS</PALLET_SIZE_TYPE>
<MARKED_PACK>REGULAR STANDARD LABEL</MARKED_PACK>
<BULK_DENSITY>122</BULK_DENSITY>
<PPG>AS33</PPG>
<HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
<ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
<JOB_STATUS>Complete</JOB_STATUS>
<LOT_NUMBER>010508001</LOT_NUMBER>
<COMPONENTS>
<COMPONENTS_ROW num="1">
<OPERATION_SEQ_NUM>1</OPERATION_SEQ_NUM>
<COMPONENT_ITEM>3E1120102390</COMPONENT_ITEM>
<COMPONENT_DESCRIPTION>W&C
E-112/WHITE-1239</COMPONENT_DESCRIPTION>
<COMPONENT_QUANTITY>1</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
</COMPONENTS>
<OPERATIONS/>
</ROW>
</ROWSET>
Here is what I do.
Read this into a data set and then write it out using the WriteXMLSchema
method.
Here is a brief example in c#.
DataSet ds = new DataSet("MyXML");
ds.ReadXml("C:\\c53a1602ff3011d48d140004ac5e3ab0.x ml");
ds.WriteXmlSchema("C:\\MyXML.xsd");
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sqlxml problem Please help"
<sqlxmlproblemPleasehelp@.discussions.microsoft.com > wrote in message
news:3B1097A3-88B2-432F-8CA9-FACB0C063997@.microsoft.com...
> hello all.
> i attached an xml that need to put data into and sql server tables
> i having probleams creating the XSD schema.
> i allready have the tables in the sql
> i am using the SQLXMLBulkLoad object. and wrote a program with vb.net
> that
> do it.
> it's work fine for simple xml and Xsd .
> i need help writing the xsd that will insert to data into 2 tables with
> relation (that i created )
> attached the xml
> please help
> thanks
>
> <?xml version = '1.0'?>
> <ROWSET>
> <ROW num="1">
> <JOB_NUMBER>3</JOB_NUMBER>
> <JOB_TYPE>STANDARD</JOB_TYPE>
> <ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>WC E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>10000</ASSEMBLY_QUANTITY>
> <CUSTOMER_NUMBER>? ? ??</CUSTOMER_NUMBER>
> <PRODUCTION_LINE>L02</PRODUCTION_LINE>
> <BULK_DENSITY>122</BULK_DENSITY>
> <PPG>AS33</PPG>
> <HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Released</JOB_STATUS>
> <LOT_NUMBER>3</LOT_NUMBER>
> <COMPONENTS>
> <COMPONENTS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>GILADI-510
> CHALK</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>1200</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>DOP
> DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>3220</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>EDENOL
> D-82,HENKEL</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>160</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
> E2400L</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>50</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
> 2WH1061</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>100</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>SOLVIN 270PF
> SOLVAY</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>5020</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/28/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> </COMPONENTS>
> <OPERATIONS>
> <OPERATIONS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>ELEC02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>2.5</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>SETUP02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>42.999656</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PROD02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>30.0003</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>NONPROD02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>COLORMAT02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>4</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PREMIX02</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>4</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> </OPERATIONS>
> </ROW>
> <ROW num="2">
> <JOB_NUMBER>4</JOB_NUMBER>
> <JOB_TYPE>PACKING</JOB_TYPE>
> <ASSEMBLY_NUMBER>11PVCNZ0004B</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>SOLVIN 270PF SOLVAY</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>100</ASSEMBLY_QUANTITY>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Unreleased</JOB_STATUS>
> <COMPONENTS/>
> <OPERATIONS/>
> </ROW>
> <ROW num="3">
> <JOB_NUMBER>5</JOB_NUMBER>
> <JOB_TYPE>PACKING</JOB_TYPE>
> <ASSEMBLY_NUMBER>347200000000</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>P.V.C SOFT 472/NAT.0000</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>100</ASSEMBLY_QUANTITY>
> <BULK_DENSITY>44949</BULK_DENSITY>
> <PPG>JHY0992</PPG>
> <HUMIDITY__PERMITTED>0.998</HUMIDITY__PERMITTED>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Unreleased</JOB_STATUS>
> <COMPONENTS/>
> <OPERATIONS/>
> </ROW>
> <ROW num="4">
> <JOB_NUMBER>6</JOB_NUMBER>
> <JOB_TYPE>STANDARD</JOB_TYPE>
> <ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>2</ASSEMBLY_QUANTITY>
> <BULK_DENSITY>122</BULK_DENSITY>
> <PPG>AS33</PPG>
> <HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Released</JOB_STATUS>
> <LOT_NUMBER>6</LOT_NUMBER>
> <COMPONENTS>
> <COMPONENTS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>GILADI-510
> CHALK</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.24</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>DOP
> DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.644</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>EDENOL
> D-82,HENKEL</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.032</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
> E2400L</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.01</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
> 2WH1061</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.02</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>SOLVIN 270PF
> SOLVAY</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>1.004</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/29/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> </COMPONENTS>
> <OPERATIONS>
> <OPERATIONS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>ELEC04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>7.518797</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>SETUP04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>40</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PROD04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>23.809524</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>NONPROD04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>COLORMAT04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PREMIX04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> </OPERATIONS>
> </ROW>
> <ROW num="5">
> <JOB_NUMBER>7</JOB_NUMBER>
> <JOB_TYPE>STANDARD</JOB_TYPE>
> <ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>1</ASSEMBLY_QUANTITY>
> <BULK_DENSITY>122</BULK_DENSITY>
> <PPG>AS33</PPG>
> <HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Complete</JOB_STATUS>
> <LOT_NUMBER>7</LOT_NUMBER>
> <COMPONENTS>
> <COMPONENTS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>12CCCUZ00090</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>GILADI-510
> CHALK</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.12</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>13PLAPY00010</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>DOP
> DI-OCTYL-PHTHALATE</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.322</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>14STBEY00170</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>EDENOL
> D-82,HENKEL</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.016</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>15LUBEY00240</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>LOXIOL G40, ADVALUB
> E2400L</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.005</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>17WITZ100030</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>TIO2,2220(CL220)KRONOS
> 2WH1061</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.01</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>11PVCNZ0004B</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>SOLVIN 270PF
> SOLVAY</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.502</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> <COMPONENTS_ROW num="7">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <DEPARTMENT>PVC</DEPARTMENT>
> <COMPONENT_ITEM>14STBLX00034</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>AKROPAN 2143GX
> AKDENIZ</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>0.025536</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> </COMPONENTS>
> <OPERATIONS>
> <OPERATIONS_ROW num="1">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>ELEC04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>7.518797</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="2">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>SETUP04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>40</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="3">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PROD04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>23.809524</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="4">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>NONPROD04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>0</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="5">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>COLORMAT04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> <OPERATIONS_ROW num="6">
> <OPERATION_SEQ_NUM>10</OPERATION_SEQ_NUM>
> <RESOURCE_CODE>PREMIX04</RESOURCE_CODE>
> <REQUIRED_PRODUCTION>52.631579</REQUIRED_PRODUCTION>
> </OPERATIONS_ROW>
> </OPERATIONS>
> </ROW>
> <ROW num="6">
> <JOB_NUMBER>9</JOB_NUMBER>
> <JOB_TYPE>PACKING</JOB_TYPE>
> <ASSEMBLY_NUMBER>3E1120102390</ASSEMBLY_NUMBER>
> <ASSEMBLY_DESCRIPTION>W&C E-112/WHITE-1239</ASSEMBLY_DESCRIPTION>
> <ASSEMBLY_QUANTITY>1</ASSEMBLY_QUANTITY>
> <CUSTOMER_NUMBER>? ? ??</CUSTOMER_NUMBER>
> <PACK_TYPE>PE BAG WITHOUT LOGO</PACK_TYPE>
> <PACK_CODE>PBR</PACK_CODE>
> <PALLET_SIZE_TYPE>TELMA PALLET HOLIS</PALLET_SIZE_TYPE>
> <MARKED_PACK>REGULAR STANDARD LABEL</MARKED_PACK>
> <BULK_DENSITY>122</BULK_DENSITY>
> <PPG>AS33</PPG>
> <HUMIDITY__PERMITTED>0.09787</HUMIDITY__PERMITTED>
> <ITEM_PRIMARY_UOM_CODE>KG</ITEM_PRIMARY_UOM_CODE>
> <JOB_STATUS>Complete</JOB_STATUS>
> <LOT_NUMBER>010508001</LOT_NUMBER>
> <COMPONENTS>
> <COMPONENTS_ROW num="1">
> <OPERATION_SEQ_NUM>1</OPERATION_SEQ_NUM>
> <COMPONENT_ITEM>3E1120102390</COMPONENT_ITEM>
> <COMPONENT_DESCRIPTION>W&C
> E-112/WHITE-1239</COMPONENT_DESCRIPTION>
> <COMPONENT_QUANTITY>1</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> </COMPONENTS>
> <OPERATIONS/>
> </ROW>
> </ROWSET>
|||Dear Hilary
i need to write a Mapping Scehma.
which i do not know to to do.
can you please help me.
i allredy write a source in vb.net that read the XML and The XSD and insert
into SQL
all i need is the right schema according to the XML below
thanks.
"Hilary Cotter" wrote:
[vbcol=seagreen]
> Here is what I do.
> Read this into a data set and then write it out using the WriteXMLSchema
> method.
> Here is a brief example in c#.
> DataSet ds = new DataSet("MyXML");
> ds.ReadXml("C:\\c53a1602ff3011d48d140004ac5e3ab0.x ml");
> ds.WriteXmlSchema("C:\\MyXML.xsd");
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "sqlxml problem Please help"
> <sqlxmlproblemPleasehelp@.discussions.microsoft.com > wrote in message
> news:3B1097A3-88B2-432F-8CA9-FACB0C063997@.microsoft.com...
|||I normally do this as part of a manual process. I create stored procedures
to fire the xml data into the respective tables.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sqlxml problem Please help"
<sqlxmlproblemPleasehelp@.discussions.microsoft.com > wrote in message
news:1D7DBF7A-E015-448C-883C-72839C357484@.microsoft.com...[vbcol=seagreen]
> Dear Hilary
> i need to write a Mapping Scehma.
> which i do not know to to do.
> can you please help me.
> i allredy write a source in vb.net that read the XML and The XSD and
> insert
> into SQL
> all i need is the right schema according to the XML below
> thanks.
> "Hilary Cotter" wrote:
|||You can also open the Xml file in the Xml editor (in VS 2005) and click on
the create schema icon.
To get the mapping information check-out the SQLXML help.
Thanks,
Avner Aharoni[MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hilary Cotter" wrote:
[vbcol=seagreen]
> I normally do this as part of a manual process. I create stored procedures
> to fire the xml data into the respective tables.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "sqlxml problem Please help"
> <sqlxmlproblemPleasehelp@.discussions.microsoft.com > wrote in message
> news:1D7DBF7A-E015-448C-883C-72839C357484@.microsoft.com...