> ok, will look at SSIS.
>
> There aren't any tables. Looked at some of the bigger XML files, they
> look very complicated, meaning multiple tables.
> That is the basis of my question: two different (non-profit) groups,
> putting out Schema's for people like me and we have to sort through huge
> xsd files to figure out multiple table relationships...just does not make
> sense.
> My gut feeling says, the xsd has enough schema data in it.
>
> We are not looking for triggers, etc out of the relationship; all I want
> is the "raw" data in the tables. There are so many xsd files and
> corresponding xml data files. Examining the relationships and modifying
> the xsd's nearly not an option - I would think.
>
> It is up to you.....wait until I deal with Integration Services, which did
> not want to install itself last week on a Win 2008 with SQL 2008 RTM.
> Have another Win2008 machine, will play with that.
>
> Still don't understand, if SQLXML "has to" have the relationship hints,
> how SSIS will figure it out without them.
>
> Don't want to ask the data suppliers (European Governments); as getting a
> question answered by them takes months.
>
> Thanks a billion for your kind help
>
>
> "Jacob Sebastian" gmail.com> wrote in message
> news:1E46AB18-7187-452B-B83E-B382693424FE@microsoft.com...

>> The annotation section defines the relationship between the tables, that
>> the Xml Bulk Load component use to load data into the tables. So if it is
>> missing, XML bulk load does not have a way to identify which table to
>> populate and which piece data should go to which column.
>>
>> Do each XML file contain data for a single table? Since you don't have
>> annotation/relationship information, SSIS might be a better option for
>> you IMHO.
>> --
>> Jacob Sebastian
>> SQL Server MVP
>> http://www.sqlserverandxml.com
>>
>> "Travis McGee" hotmail.com> wrote in message
>> news:ezjMi7eAJHA.4748@TK2MSFTNGP06.phx.gbl...

>>> So..... we have these files from different vendors in XML to be loaded
>>> into SQL Server.
>>> Looks like they don't have the annotation/relationship sections at the
>>> towards the top of the files.
>>> These are complicated schemas and people who were creating them knew
>>> what they were doing.
>>> Is there another way of "creating" the tables out of the xsd's even if
>>> the schema does not have annotation section and then inserting the xml
>>> data.
>>>
>>> XML did not arrive to make our lives more difficult since we got along
>>> well with flat files since the French Revolution, right?
>>>
>>>
>>>