annotation issue with SQLXML

I am getting "relationship expected on" errors on SQLXML Loading Code when I
am creating the tables and then perhaps adding.inserting the data.

These are small files
http://www.HumanGenome.org/data/schema1.xsd
http://www.HumanGenome.org/data/data1.xml
is giving me....relationship expected on 'ING'

and then
http://www.HumanGenome.org/data/schema2.xsd
http://www.HumanGenome.org/data/data2.xml
is giving me....relationship expected on 'COMBINATION_PACK_IND'

This has something to do with missing annotation, I think.

Can somebody help me

Lilya Lopekha

It looks to be a duplicate post and I have replied to the previous thread.
If you are loading data using XML Bulk Load, your schema should have some
additional information that explains the tables, columns, relationships etc.
Please have a look at the example here:
http://www.sqlserverandxml.com/2008/08/sqlxml-lab-2-basic-xml-bulk-load.html

regards
--
Jacob Sebastian
SQL Server MVP
http://www.sqlserverandxml.com

"Travis McGee" <travisGatesMcGee DeleteThis @hotmail.com> wrote in message
news:eC8bxgYAJHA.1184@TK2MSFTNGP04.phx.gbl...
> I am getting "relationship expected on" errors on SQLXML Loading Code when
> I am creating the tables and then perhaps adding.inserting the data.
>
> These are small files
> http://www.HumanGenome.org/data/schema1.xsd
> http://www.HumanGenome.org/data/data1.xml
> is giving me....relationship expected on 'ING'
>
> and then
> http://www.HumanGenome.org/data/schema2.xsd
> http://www.HumanGenome.org/data/data2.xml
> is giving me....relationship expected on 'COMBINATION_PACK_IND'
>
> This has something to do with missing annotation, I think.
>
> Can somebody help me
>
> Lilya Lopekha
>
>
>
>
>
>
>
>