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

Other
1

Introduction

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

Prerequisites

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

  • A local XML file

Steps

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

  2. Inside the Data Flow, add a XML 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 57.6 KB

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

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

  8. Select an Output option

  9. Now right-click on the Mappings to add element(s) or unbound array/nested elements to your new JSON file. Following is an example.

    image
    image785×779 70.8 KB

  10. Press the OK button to save it

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

    image
    image1199×397 31.9 KB

Video Tutorial

Conclusion

Following these steps, you can seamlessly cover the basic steps to convert an XML file to a JSON 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