|
Home > Archive > BizTalk Server Orchestration > July 2004 > Insert into SQL table not successful
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 |
Insert into SQL table not successful
|
|
| human fly 2004-07-22, 5:56 pm |
| 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
| |
| Michael Høtoft 2004-07-23, 7:49 am |
| 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
>
>
>
| |
| humanfly 2004-07-23, 5:50 pm |
| Hi Mike,
No, I do not get any error. Would really appreciate if you could guide me to use HAT to pin-point the error.
thanks
"Michael Høtoft" wrote:
> 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...
> from one location to another, it does not get trnsmitted. Please advise.
> inserting into a sql table:
> attributeFormDefault="unqualified" elementFormDefault="qualified"
> xmlns:xs="http://www.w3.org/2001/XMLSchema">
> type="xs:string" />
> />
>
>
>
|
|
|
|
|