Re: SQL/XML Annotation Question - a different take

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

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
    ... Struggling with SSIS. ... It does not like the xsd file....but have more ... Looked at some of the bigger XML files, ... Looks like they don't have the annotation/relationship sections at the ...
    (microsoft.public.sqlserver.xml)
  • URGENT - Using XML Source - Related issues and usage
    ... Using XML Source - Related issues and usage ... Already tried to look for articles on the net and consulted Help inside SSIS ... The job is to get this XML data directly in to a SQL Server database table ...
    (microsoft.public.sqlserver.xml)
  • Re: SQL/XML Annotation Question - a different take
    ... I guess the question you are referring is the SSIS question "how does ssis finds the relationship". ... SQL Server MVP ... Looked at some of the bigger XML files, they look very complicated, meaning multiple tables. ... That is the basis of my question: two different 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. ...
    (microsoft.public.sqlserver.xml)
  • Re: Xml datasource for the cubes
    ... DAve, thank you for your answer, but as I am a newby on this subject, could ... > You can load XML structured data via SSIS and then SSIS can pump that data ... > not read the XML data; but SSIS can and then hand it off to AS. ... > SQL BI Product Unit ...
    (microsoft.public.sqlserver.olap)
  • RE: how to import an xml file to sql
    ... Bass Industries Matinee Lounger ... For books online do I just look for SSIS? ... If you post a sample of the XML ...
    (microsoft.public.sqlserver.datawarehouse)