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


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


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

  • A local XML file


  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

  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.

  10. Press the OK button to save it

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

Video Tutorial


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