Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Bulk Load question ... please help

Author  Topic  dev_guy Starting Member 3 Posts Posted - 2005-02-18 : 11:46:39 Hi there, In the XSD schema I have element name="kategorie" with a 'title' atribute. What I want is to have this atribute in tblImportSpeisekarte table too. For some reason I cannot import this ... please help! - <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sql="urn:schemas-microsoft-com:mapping-schema"> - <xsd:annotation> - <xsd:appinfo> <sql:relationship name="aaa" parent="lokalkey" parent-key="id" child="lbild" child-key="id" /> <sql:relationship name="bbb" parent="lokalkey" parent-key="id" child="tblImportSpeisekarte" child-key="id" /> </xsd:appinfo> </xsd:annotation> - <xsd:element name="lokal" sql:relation="lokalkey"> - <xsd:complexType> - <xsd:sequence> <xsd:element name="id" type="xsd:string" /> <xsd:element name="lokalname" type="xsd:string" /> - <xsd:element name="bilder" sql:is-constant="1"> - <xsd:complexType> - <xsd:sequence> - <xsd:element name="bild" sql:relation="lbild" sql:relationship="aaa" maxOccurs="unbounded"> - <xsd:complexType> <xsd:attribute name="kategorie" type="xsd:string" /> <xsd:attribute name="name" type="xsd:string" /> <xsd:attribute name="referenz" type="xsd:string" /> </xsd:complexType> </xsd:element> </xsd:sequence> </xsd:complexType> </xsd:element> - <xsd:element name="speisekarte" sql:is-constant="1"> - <xsd:complexType> - <xsd:sequence> - <xsd:element name="kategorie"> - <xsd:complexType> - <xsd:sequence> - <xsd:element name="eintrag" sql:relation="tblImportSpeisekarte" sql:relationship="bbb" maxOccurs="unbounded"> - <xsd:complexType> <xsd:attribute name="titel" type="xsd:string" /> <xsd:attribute name="text" type="xsd:string" /> <xsd:attribute name="zusatztext" type="xsd:string" /> <xsd:attribute name="preis" type="xsd:string" /> </xsd:complexType> </xsd:element> </xsd:sequence> <xsd:attribute name="title" sql:field="kategorie" sql:relationship="bbb" type="xsd:string" /> </xsd:complexType> </xsd:element> </xsd:sequence> </xsd:complexType> </xsd:element> </xsd:sequence> </xsd:complexType> </xsd:element> </xsd:schema>