Post reply

Loading xml into sql server - ssis

  • October 14, 2009 at 8:40 am

    #135772

    Hi,

    I have a xml whose structure is as below:

    <ns:abcd-XMLInterchange xmlns:dc="http://axc.net/dc/elements/1.1/" xmlns:dcq="http://axc.net/dc/terms/" xmlns:gms="http://www.abcded.gov/CM/gms" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.abcd.us/DataStandards/XMLschema/acd/ns https://edt-schema.uk/schema/acd/6.0/XML_Message_Root-V6-0-2008-01-14.xsd" SchemaVersion="6-0" SchemaDate="2008-01-14" xmlns:ns="http://www.test.us/DataStandards/XMLschema/ns">

    <ns:Header>

    <ns:PersonGeneralinfo>

    <ns:Name>abcded</ns:Name>

    <ns:Country>abcded</ns:Country>

    <ns:OrderInformation>

    <ns:OrderID>123</ns:OrderID>

    <ns:OrderID>4564</ns:OrderID>

    </ns:OrderInformation>

    </ns:PersonGeneralinfo>

    <ns:PersonOtherInfo>

    <ns:Info1>abcded</ns:Info1>

    </ns:PersonOtherInfo>

    </ns:Header>

    </ns:abcd-XMLInterchange>

    I want to load the above xml into the SQL tables - Table Person with fields Name,Country & Info1. Table Orders with fields OrderID (multiple rows)

    How do I do this above in ssis? If it is a simple xml then xmlsource works fine.

    Any technical example is appreciated.

    Thanks

    Suga

    email id: Sugaz007@hotmail.com

  • October 14, 2009 at 8:52 am

    #1065740

    Yeah, use and XML source and link each node up to a seperate OLE DB Destination. These can point to the same table; however, there needs to be a destination for each output from the source.

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

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