none
How to create XML based on XSD configuration from Database using SSIS Tool without any coding RRS feed

  • Question

  • Hi All,

    I want to create XML based on XSD configuration from Database using SSIS Tool without any coding. Is there any option where we can upload XSD and map data to XSD configuration directly from DB to generate XML for multi levels? Please help on this options.

    Sample XML:

    <Root xmlns:xsi="http://www.w3.org/2001/XMLSchema" xmlns:abc="http://xyz.com">
    <header>
    <totalCount>1</totalCount>
    </header>
    <Request>
    <InventoryList>
    <Count>1</Count>
    <Record>
    <Id>1</Id>
    <Inventory>
    <InventoryDetails xmlns = "">
    <PayType>COD</PayType>
    <receiptNumber>123456789</receiptNumber>
    <PurchaseList>
    <purchaseId>524</purchaseId>
    <ItemCodes>
    <itemCode>2563</itemCode>
    </ItemCodes>
    <purchaseDate>2019-07-13</purchaseDate>
    <quantity>1</quantity>
    </PurchaseList>
    <PurchaseList>
    <purchaseId>525</purchaseId>
    <ItemCodes>
    <itemCode>546</itemCode>
    </ItemCodes>
    <purchaseDate>2019-07-13</purchaseDate>
    <quantity>1</quantity>
    </PurchaseList>
    <Addresses>
    <address>
    <addressType>Billing</addressType>
    <ContactDetails>
    <contact>
    <contactType>Phone</contactType>
    <contactCode>123456</contactCode>
    </contact>
    </ContactDetails>
    </address>
    <address>
    <addressType>Shipping</addressType>
    <ContactDetails>
    <contact>
    <contactType>Phone</contactType>
    <contactCode>123456</contactCode>
    </contact>
    <contact>
    <contactType>Fax</contactType>
    <contactCode>123456</contactCode>
    </contact>
    </ContactDetails>
    </address>
    </Addresses>
    <ShippingCode>ABC</ShippingCode>
    </InventoryDetails>
    </Inventory>
    </Record>
    </InventoryList>
    </Request>
    </Root>

    Thanks!!


    • Edited by Pavisub Saturday, October 24, 2020 3:22 PM
    Saturday, October 24, 2020 3:21 PM

All replies

  • Hi Pavisub:

    This forum is dedicated to supporting issues related to open specification. You can access open specifications at https://docs.microsoft.com/en-us/openspecs/. Your inquiry does not seem to be related to open specifications.

    For a better chance of getting an answer to your question, you may want to post your question to the following forum:

    https://docs.microsoft.com/en-us/answers/topics/sql-server-integration-services.html


    Regards, Obaid Farooqi

    Saturday, October 24, 2020 7:41 PM
    Owner