|
Home > Archive > MS SQL XML > December 2005 > Please help. i need to create an XSD and dont know how!
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Please help. i need to create an XSD and dont know how!
|
|
| sqlxml problem Please help 2005-12-21, 7:23 am |
| 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_COD
E>KG</ ITEM_PRIMARY_UOM_COD
E>
<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_DESCRIPTIO
N>GILADI-510 CHALK</ COMPONENT_DESCRIPTIO
N>
<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_DESCRIPTIO
N>DOP
DI-OCTYL-PHTHALATE</ COMPONENT_DESCRIPTIO
N>
<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_DESCRIPTIO
N>EDENOL D-82,HENKEL</ COMPONENT_DESCRIPTIO
N>
<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_DESCRIPTIO
N>LOXIOL G40, ADVALUB
E2400L</ COMPONENT_DESCRIPTIO
N>
<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_DESCRIPTIO
N> TIO2,2220(CL220)KRON
OS
2WH1061</ COMPONENT_DESCRIPTIO
N>
<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_DESCRIPTIO
N>SOLVIN 270PF
SOLVAY</ COMPONENT_DESCRIPTIO
N>
<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_COD
E>KG</ ITEM_PRIMARY_UOM_COD
E>
<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_COD
E>KG</ ITEM_PRIMARY_UOM_COD
E>
<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_COD
E>KG</ ITEM_PRIMARY_UOM_COD
E>
<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_DESCRIPTIO
N>GILADI-510 CHALK</ COMPONENT_DESCRIPTIO
N>
<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_DESCRIPTIO
N>DOP
DI-OCTYL-PHTHALATE</ COMPONENT_DESCRIPTIO
N>
<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_DESCRIPTIO
N>EDENOL D-82,HENKEL</ COMPONENT_DESCRIPTIO
N>
<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_DESCRIPTIO
N>LOXIOL G40, ADVALUB
E2400L</ COMPONENT_DESCRIPTIO
N>
<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_DESCRIPTIO
N> TIO2,2220(CL220)KRON
OS
2WH1061</ COMPONENT_DESCRIPTIO
N>
<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_DESCRIPTIO
N>SOLVIN 270PF
SOLVAY</ COMPONENT_DESCRIPTIO
N>
<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_COD
E>KG</ ITEM_PRIMARY_UOM_COD
E>
<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_DESCRIPTIO
N>GILADI-510 CHALK</ COMPONENT_DESCRIPTIO
N>
<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_DESCRIPTIO
N>DOP
DI-OCTYL-PHTHALATE</ COMPONENT_DESCRIPTIO
N>
<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_DESCRIPTIO
N>EDENOL D-82,HENKEL</ COMPONENT_DESCRIPTIO
N>
<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_DESCRIPTIO
N>LOXIOL G40, ADVALUB
E2400L</ COMPONENT_DESCRIPTIO
N>
<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_DESCRIPTIO
N> TIO2,2220(CL220)KRON
OS
2WH1061</ COMPONENT_DESCRIPTIO
N>
<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_DESCRIPTIO
N>SOLVIN 270PF
SOLVAY</ COMPONENT_DESCRIPTIO
N>
<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_DESCRIPTIO
N>AKROPAN 2143GX
AKDENIZ</ COMPONENT_DESCRIPTIO
N>
<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_COD
E>KG</ ITEM_PRIMARY_UOM_COD
E>
<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_DESCRIPTIO
N>W&C
E-112/WHITE-1239</ COMPONENT_DESCRIPTIO
N>
<COMPONENT_QUANTITY>1</COMPONENT_QUANTITY>
<REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
</COMPONENTS_ROW>
</COMPONENTS>
<OPERATIONS/>
</ROW>
</ROWSET>
| |
| Hilary Cotter 2005-12-21, 9:23 am |
| 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:\\c53a1602ff3011d4
8d140004ac5e3ab0.xml");
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"
< sqlxmlproblemPleaseh
elp@discussions.microsoft.com> wrote in message
news:3B1097A3-88B2-432F-8CA9- FACB0C063997@microso
ft.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_COD
E>KG</ ITEM_PRIMARY_UOM_COD
E>
> <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_DESCRIPTIO
N>GILADI-510
> CHALK</ COMPONENT_DESCRIPTIO
N>
> <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_DESCRIPTIO
N>DOP
> DI-OCTYL-PHTHALATE</ COMPONENT_DESCRIPTIO
N>
> <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_DESCRIPTIO
N>EDENOL
> D-82,HENKEL</ COMPONENT_DESCRIPTIO
N>
> <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_DESCRIPTIO
N>LOXIOL G40, ADVALUB
> E2400L</ COMPONENT_DESCRIPTIO
N>
> <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_DESCRIPTIO
N> TIO2,2220(CL220)KRON
OS
> 2WH1061</ COMPONENT_DESCRIPTIO
N>
> <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_DESCRIPTIO
N>SOLVIN 270PF
> SOLVAY</ COMPONENT_DESCRIPTIO
N>
> <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_COD
E>KG</ ITEM_PRIMARY_UOM_COD
E>
> <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_COD
E>KG</ ITEM_PRIMARY_UOM_COD
E>
> <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_COD
E>KG</ ITEM_PRIMARY_UOM_COD
E>
> <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_DESCRIPTIO
N>GILADI-510
> CHALK</ COMPONENT_DESCRIPTIO
N>
> <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_DESCRIPTIO
N>DOP
> DI-OCTYL-PHTHALATE</ COMPONENT_DESCRIPTIO
N>
> <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_DESCRIPTIO
N>EDENOL
> D-82,HENKEL</ COMPONENT_DESCRIPTIO
N>
> <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_DESCRIPTIO
N>LOXIOL G40, ADVALUB
> E2400L</ COMPONENT_DESCRIPTIO
N>
> <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_DESCRIPTIO
N> TIO2,2220(CL220)KRON
OS
> 2WH1061</ COMPONENT_DESCRIPTIO
N>
> <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_DESCRIPTIO
N>SOLVIN 270PF
> SOLVAY</ COMPONENT_DESCRIPTIO
N>
> <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_COD
E>KG</ ITEM_PRIMARY_UOM_COD
E>
> <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_DESCRIPTIO
N>GILADI-510
> CHALK</ COMPONENT_DESCRIPTIO
N>
> <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_DESCRIPTIO
N>DOP
> DI-OCTYL-PHTHALATE</ COMPONENT_DESCRIPTIO
N>
> <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_DESCRIPTIO
N>EDENOL
> D-82,HENKEL</ COMPONENT_DESCRIPTIO
N>
> <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_DESCRIPTIO
N>LOXIOL G40, ADVALUB
> E2400L</ COMPONENT_DESCRIPTIO
N>
> <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_DESCRIPTIO
N> TIO2,2220(CL220)KRON
OS
> 2WH1061</ COMPONENT_DESCRIPTIO
N>
> <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_DESCRIPTIO
N>SOLVIN 270PF
> SOLVAY</ COMPONENT_DESCRIPTIO
N>
> <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_DESCRIPTIO
N>AKROPAN 2143GX
> AKDENIZ</ COMPONENT_DESCRIPTIO
N>
> <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_COD
E>KG</ ITEM_PRIMARY_UOM_COD
E>
> <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_DESCRIPTIO
N>W&C
> E-112/WHITE-1239</ COMPONENT_DESCRIPTIO
N>
> <COMPONENT_QUANTITY>1</COMPONENT_QUANTITY>
> <REQUIRED_DATE>11/30/2005 0:0:0</REQUIRED_DATE>
> </COMPONENTS_ROW>
> </COMPONENTS>
> <OPERATIONS/>
> </ROW>
> </ROWSET>
| |
| sqlxml problem Please help 2005-12-22, 3:24 am |
| 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:
[color=darkred]
> 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:\\c53a1602ff3011d4
8d140004ac5e3ab0.xml");
>
> 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"
> < sqlxmlproblemPleaseh
elp@discussions.microsoft.com> wrote in message
> news:3B1097A3-88B2-432F-8CA9- FACB0C063997@microso
ft.com...
| |
| Hilary Cotter 2005-12-25, 8:23 pm |
| 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"
< sqlxmlproblemPleaseh
elp@discussions.microsoft.com> wrote in message
news:1D7DBF7A-E015-448C-883C- 72839C357484@microso
ft.com...[color=darkred]
> 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:
>
| |
| Avner Aharoni [MSFT] 2005-12-31, 8:23 pm |
| 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:
[color=darkred]
> 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"
> < sqlxmlproblemPleaseh
elp@discussions.microsoft.com> wrote in message
> news:1D7DBF7A-E015-448C-883C- 72839C357484@microso
ft.com...
|
|
|
|
|