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.

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