Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

BULK LOAD

 
   Database Help (Home) -> XML RSS
Next:  Using IF statement or CASE in view?  
Author Message
NateZ

External


Since: Oct 30, 2008
Posts: 1



(Msg. 1) Posted: Thu Oct 30, 2008 10:11 am
Post subject: BULK LOAD
Archived from groups: microsoft>public>sqlserver>xml (more info?)

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>

 >> Stay informed about: BULK LOAD 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
XML Bulk Load - I am trying to upload data from my XML file to SQL database using xsd schema file. I am doing using the XML bulkload in VB. The piece of code I have writted is as follows : Dim objXBulkLoad as object Set objXBulkLoad =..

Help - XML bulk load to M:N with attributes - Hi all. I am new to XML bulk load. I am trying to load an XML document into an M:N relation with additional attributes. The actual XML file and table structures are similar to the supplied specs. I have read about how to use the chaining relationships to...

SQL XML Bulk Load in a Windows Service - Hi, I'm trying to use the XML Bulk Load object in a Windows service. To do this i've written the following method: private void uploadXML() { try { SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class objBL = new ..

Third post of the same problem load XML file using bulk in.. - Sorry for my insistence, but his is my third post of the same problem, none can help me, i really need help ... I tried to load a file (Data.xml) into SQLServer 2000 using Schema.xml file but when i load the file i check the table and nothing was..

xsd sql schema relation problem bulk load - self join - Here is a snippet of my xml (based on the ecb daily) and with xmlns removed: <?xml version="1.0" encoding="UTF-8"?> <gesmes> <Cube> <Cube time='2006-11-01'> <Cube currency='USD' rate='1.2757'/> ...
   Database Help (Home) -> XML All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]