By the way, we were trying to do Bulk Insert with SQLXML.
We also have SQL 2008; can it handle schema's without the annotation section
in order to create the tables, ie. Integration Services, etc.
++++++++++++++++++++

"Travis McGee" <travisGatesMcGee@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?
>
>
>