Introduction
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
Prerequisites
- SSIS PowerPack: Download and install the ZappySys SSIS PowerPack from the Customer Download Area or get the trial version.
Steps
-
Add a Data Flow task to your SSIS package.
-
Inside the Data Flow, add a Source component with an XML inside one column; here is our example with an JSON Source:
-
Another source component is using XML source with the option Output as RAW document checked:
-
Copy the XML from that column to use in the next component.
-
Now drop the XML Parser Transform and connect it to the source component.
-
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.
-
Select a destination component, Trash Destination, and run the package. You can use Enable Data Viewer to check the result.
Considerations
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
Conclusion
Following these steps, you can seamlessly parse an XML within SSIS. For assistance or inquiries, contact our support team via chat on our website.