Re: SQL/XML Annotation Question - a different take

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Jacob,
Struggling with SSIS. It does not like the xsd file....but have more
experimentation to do. SSIS itself has gotten to be much more complicated
than the ones I have played with during beta stages of 2008.
But if you care to answer my burning question below...please feel free.
Thanks.....+ will post the result of my efforts probably tomorrow sometime.
Thanks again for all of your help.
Lilya :)



"Travis McGee" <travisGatesMcGee@xxxxxxxxxxx> wrote in message
news:OD%23i6zfAJHA.3728@xxxxxxxxxxxxxxxxxxxxxxx
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" <jacob.reliancesp@xxxxxxxxx> wrote in message
news:1E46AB18-7187-452B-B83E-B382693424FE@xxxxxxxxxxxxxxxx
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" <travisGatesMcGee@xxxxxxxxxxx> wrote in message
news:ezjMi7eAJHA.4748@xxxxxxxxxxxxxxxxxxxxxxx
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?





.

Relevant Pages

  • Re: SQL/XML Annotation Question - a different take
    ... Looked at some of the bigger XML files, they look very complicated, meaning multiple tables. ... Still don't understand, if SQLXML "has to" have the relationship hints, how SSIS will figure it out without them. ... Since you don't have annotation/relationship information, SSIS might be a better option for you IMHO. ...
    (microsoft.public.sqlserver.xml)
  • Re: Cannot deserialize XML even though it validates against generated XSD file.
    ... referencing the derived classes. ... I have generated XSD from the classes for this ... I have made an XML file that validates against that XSD. ... However, when I try to deserialize from the XML file, I get complaints ...
    (microsoft.public.dotnet.general)
  • Re: Representing Biz Entity in XML: Use XMLSerializer or custom using XSD?
    ... For dehydrating objects to Xml, ... app in one situation where I wanted to do this (eg, not serialize some ... BusinessEntity since currently our BusinessEntity is a custom .NET class ... > So I was thinking that we just define an XSD outside of the BusinessEntity ...
    (microsoft.public.dotnet.framework.webservices)
  • defining objects with xml/schema
    ... represent the classes in xml and auto-generate them ... will be hard for other people who don't have a grasp of xsd schema. ... indicates a code generator option. ... public class item2Object ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Map XSD/XML data to VB.net classes
    ... XML (based on the XSD), it will be XML that can be deserialised into a .NET ... Maybe someone else who knows about InfoPath can help a bit more. ... > XSD available for each form template. ...
    (microsoft.public.dotnet.xml)