Post reply

Importing from XML doc. Multiple tables in same XML?

  • January 20, 2011 at 2:20 pm

    #230672

    I've got an XML file I've connected to via XML Source transformation. I let it build a schema for it and head over to Column mappings display. There, in the drop down, are 4 seperate Output names, and each one is associated with different data in the xml. If I am to believe the XML Editor, the XML file has 4 seperate tables imbedded in it.

    Question:

    If there are multiple entries in XML Source Editors Output Name drop down, each delivering a separate set of columns, how do I make sure to capture the data in them all? Multiple connections to the same file, each transform pulling in columns associated with a different entry in that drop down?

  • January 27, 2011 at 8:10 am

    #1279099

    Check this article by Matt Masson.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • January 28, 2011 at 12:21 am

    #1279534

    I appreciate this. In my case the xml file is shredded into about 31 columns and this is not a viable option. I would be manipulating multiple property values hundreds of times before I completed all 31 and that is just one file.

    I have requested the XSD schema files (see post http://www.sqlservercentral.com/Forums/Topic1052762-21-2.aspx#bm1053388, where I posted this question to XML forum), and will wait and see now. Will post there when I have an update.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply