How to Parse XML in SSIS Using ZappySys XML Parser Transform


Parsing XML in SQL Server Integration Services (SSIS) can be challenging due to the complex structure of XML data. This article guides you through how to parse XML information with our XML Parser Transform; it allows you to extract and manipulate XML data within your SSIS packages efficiently



  1. Add a Data Flow task to your SSIS package.

  2. Inside the Data Flow, add a Source component with an XML inside one column; here is our example with an JSON Source:

  3. Another source component is using XML source with the option Output as RAW document checked:

  4. Copy the XML from that column to use in the next component.

  5. Now drop the XML Parser Transform and connect it to the source component.

  6. Select the column with the XML value, paste the XML example inside the component, use the filter to get the object you want, preview the data, and press OK to save the configuration.

  7. Select a destination component, Trash Destination, and run the package. You can use Enable Data Viewer to check the result.


Ensure a column has an XML value within it; otherwise, the data format issue will prevent it from working.

Video Tutorial

Watch the video tutorial


Following these steps, you can seamlessly parse an XML within SSIS. For assistance or inquiries, contact our support team via chat on our website.


XML Parser Transform