Modifying generated XSD file

Hello,

I am working with an .xml file that I want to break up into various tables. A couple of fields in my xml file include html tags (<p> tags specifically). The generated xsd file thinks these are nested xml tags and creates a "P" table for the information contained. Is there a way I can modify the generated xsd within the designer Or is the only way to fix this is to manually modify the xsd

There is also an <id> tag within the xml. However, SSIS is not using that <id> as the primary key as it adds data to the various tables that I've specified. Instead it appears to be creating its own primary key - calling it "Id". Is there some way to specify that SSIS use the <id> tag contained within the xml instead of creating its own primary key

Thank you for any help.



Answer this question

Modifying generated XSD file

  • Diego Britos

    >> Is there a way I can modify the generated xsd within the designer

    no, except "Open" | "File" and modify it manually.

    >>Is there some way to specify that SSIS use the <id> tag contained within the xml instead of creating its own primary key

    unfortunately no. As far as I know, for this realease the xmlsrc adapter (actually its underneath reader) can not tell which existing columns can be used for retaining the table hierarchy.

    Thanks

    wenyang



  • Modifying generated XSD file