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


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


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

  • A local JSON file


  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

  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.

  10. Press the OK button to save it

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

Video Tutorial


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