07-23-04 12:49 PM
Do you have an error or smething like that.
"human fly" <humanfly@discussions.microsoft.com> wrote in message
news:AE0AEC5D-E5CD-4EF2-936E-56CCCF673284@microsoft.com...
> Hi,
>
> Not only is the insertion faiing ut even if i try to move the file around
from one location to another, it does not get trnsmitted. Please advise.
> PLease find below the sample schema and data file that I am using for
inserting into a sql table:
>
> schema:
> --------
> <?xml version="1.0" encoding="utf-16"?>
> <xs:schema xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
attributeFormDefault="unqualified" elementFormDefault="qualified"
xmlns:xs="http://www.w3.org/2001/XMLSchema">
> <xs:element name="Vehicle_Raw_Data">
> <xs:complexType>
> <xs:sequence>
> <xs:element maxOccurs="unbounded" name="Model">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="Make" type="xs:string" />
> <xs:element name="Model" type="xs:string" />
> <xs:element name="Year" type="xs:unsignedShort" />
> <xs:element name="Effective_Date" type="xs:string" />
> <xs:element maxOccurs="unbounded" name="SubModel">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="ModelName" type="xs:string" />
> <xs:element name="Name" type="xs:string" />
> <xs:element name="Number" type="xs:unsignedByte" />
> <xs:element name="Invoice_FOB" type="xs:string" />
> <xs:element name="List_FOB" type="xs:string" />
> <xs:element name="Invoice_WithShipping"
type="xs:string" />
> <xs:element name="List_WithShipping" type="xs:string"
/>
> <xs:element name="ModelId" type="xs:string" />
> <xs:element name="Code" type="xs:string" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:schema>
>
> data:
> ----
> <Vehicle_Raw_Data>
> <Model>
> <Make>Make_0</Make>
> <Model>Model_0</Model>
> <Year>10</Year>
> <Effective_Date>Effective_Date_0</Effective_Date>
> <SubModel>
> <ModelName>ModelName_0</ModelName>
> <Name>Name_0</Name>
> <Number>125</Number>
> <Invoice_FOB>Invoice_FOB_0</Invoice_FOB>
> <List_FOB>List_FOB_0</List_FOB>
> <Invoice_WithShipping>Invoice_WithShipping_0</Invoice_WithShipping>
> <List_WithShipping>List_WithShipping_0</List_WithShipping>
> <ModelId>ModelId_0</ModelId>
> <Code>Code_0</Code>
> </SubModel>
> </Model>
> </Vehicle_Raw_Data>
>
> table sctructure:
> ------------------
>
> 1 Make varchar 255 1
> 0 Model varchar 255 1
> 0 [Year] varchar 255 1
> 0 SubModel_ModelName varchar 255 1
> 0 SubModel_Name varchar 255 1
> 0 ModelId varchar 255 1
> 0 Number varchar 255 1
> 0 Code varchar 255 1
> 0 Invoice_FOB varchar 255 1
> 0 List_FOB varchar 255 1
> 0 Invoice_WithShipping varchar 255 1
> 0 List_WithShipping varchar 255 1
>
>
>
[ Post a follow-up to this message ]
| 
