How to convert a JSON file to a XML file in SSIS

SSIS PowerPack XML
1

Introduction

This article will show an example of converting a JSON file to an XML file.

Prerequisites

  • SSIS PowerPack: Download and install the ZappySys SSIS PowerPack from Here.

  • A local JSON file

Steps

  1. Drag and drop a Data Flow task in your SSIS package.

  2. Inside the Data Flow, add a JSON source component.

  3. Select the JSON file you want to use

  4. Select the object you want to use in our filter option

  5. Preview the data and press OK to save it

    image
    image828×735 54.8 KB

  6. Add an XML destination component, drag and drop it, and then connect it.

  7. Enter the XML destination component and create a new connection: a flat file with the XML extension

  8. Select an Output option

  9. Now right-click on the Mappings; you can add elements() or attribute(s) to your new XML file. Following is an example.

    image
    image908×843 88 KB

  10. Press the OK button to save it

  11. Run the package to see the exported XML data.

    image
    image959×462 34.2 KB

Video Tutorial

Conclusion

Following these steps, you can seamlessly cover the basic steps to convert a JSON file to an XML file using SSIS, utilizing the ZappySys tool for efficient data retrieval and integration. If you encounter any issues or need further assistance, you can contact our support team via chat on our website

References