Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
 

Go Back   XSL - XML - RSS Forums > XML General > SQL and XML

Tags:



Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 10-30-2008, 07:18 PM
NateZ
 
Posts: n/a

Default BULK LOAD



I am getting the message Incorrect syntax near the keyword 'Transaction'. I
have looked and looke dna dlooked and searched and searched to no avail. the
XSD file is below. I left out the simple types, except for the one used by
transaction, for the sake of space. Any help would be appreciated.

<?xml version="1.0"?>
<xs:schema id="FileSummary"
xmlns:sql="urn:schemas-microsoft-com:mapping-schema"
xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:annotation>
<xs:appinfo>
<sql:relationship name="FailTrans_Trans" parent="FailedTransaction"
parent-key="TransactionType" child="Transactions"
child-key="TransactionType"/>
<sql:relationship name="FileSum_SuccTrans" parent="FileSummary"
parent-key="ProcessedFileName" child="SuccessfulTransactions"
child-key="ProcessedFileName" />
<sql:relationship name="Tl_ST" parent="FileSummary"
parent-key="ProcessedFileName" child="SuccessfulTransactions"
child-key="ProcessedFileName"/>
<sql:relationship name="ST_TR" parent="SuccessfulTransactions"
parent-key="TransactionType" child="Transactions"
child-key="TransactionType"/>
<sql:relationship name="FS_FT" parent="FileSummary"
parent-key="ProcessedFileName" child="FailedTransactions"
child-key="ProcessedFileName" />
<sql:relationship name="FT_RC" parent="FailedTransactions"
parent-key="TransactionType" child="REOCases" child-key="TransactionType" />
<sql:relationship name="RC_TR" parent="REOCases"
parent-key="TransactionType" child="Transaction" child-key="TransactionType"
/>
<sql:relationship name="FT_TR" parent="FailedTransactions"
parent-key="TransactionType" child="Transactions" child-key="TransactionType"
/>
<sql:relationship name="FS_FE" parent="FileSummary"
parent-key="ProcessedFileName" child="FileError"
child-key="ProcessedFileName"/>
</xs:appinfo>
</xs:annotation>
<xs:element name="FileSummary" sql:is-constant="true" >
<xs:complexType>
<xs:sequence>
<xs:element name="ResponseHeader" type="SummaryHeaderType" />
<xs:element name="ProcessedFileName" type="xs:string" />
<xs:element name="FileProcessedDateAndTime" type="xs:dateTime"
/>
<xs:element name="TotalTransactions" type="xs:int" />
<xs:element name="TotalSuccessfulTransactions" type="xs:int" />
<xs:element name="TotalFailedTransactions" type="xs:int" />
<xs:element minOccurs="0" name="SuccessfulTransactions"
sql:relation="SuccessfulTransactions" sql:relationship="Tl_ST" >
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" name="Transactions"
sql:relation="Transactions" sql:relationship="ST_TR"
sql:key-fields="TransactionType" type="IncomingTransactionSummaryType" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="FailedTransactions"
sql:relation="FailedTransactions" sql:relationship="FS_FT" >
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" name="Transactions"
sql:relation="Transactions" sql:relationship="FT_TR"
sql:key-fields="TransactionType" type="IncomingTransactionSummaryType" />
<xs:element maxOccurs="unbounded" name="REOCases"
sql:relation="REOCases" sql:relationship="FT_RC" sql:key-fields="reo_id">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded"
name="Transaction" sql:relation="Transaction" sql:relationship="RC_TR"
sql:key-fields="TransactionType">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded"
name="transactionType" type="IncomingTransactionTypeCode" />
<xs:element maxOccurs="unbounded"
name="errorMessage" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="reo_id" type="REOIDType" />
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="FileError"
sql:relation="FileError" sql:key-fields="ProcessedFileName"
sql:relationship="FS_FE">
<xs:complexType>
<xs:sequence>
<xs:element name="errorMessage"
type="AlphaNumeric4000Type" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:complexType>


<xs:complexType name="IncomingTransactionSummaryType">
<xs:annotation>
<xs:documentation>Transactions complex element used in File Summary
schema</xs:documentation>
</xs:annotation>
<xs:all>
<xs:element name="transactionCount" type="xs:int" />
<!--<xs:element name="transactionType" type="IncomingTransactionTypeCode"
/>-->
</xs:all>
</xs:complexType>


Reply With Quote
Sponsored Links
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



Contact Us -|- XSL - XML - RSS Forums -|- Archive -|- Top -|-Rules/Disclaimer-|-Help/Support -|-Advertise
© Camley Interactive (camley.info) 2008 - all logos and images are copywrite their respective owners.
Proud member of the Camley Interactive Network
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0 ©2007, Crawlability, Inc.
All times are GMT. The time now is 02:12 PM.
Style Developed by Epic Designz