How to configure SSIS package to parse multiple XML values



I have an SSIS package, which pulls data from an XML and loads into a table. Here is the screenshot of 1 to 1 mapping.


XML source to TABLE


Now, in the XML, I have certain sections with multiple values. Here is the screenshot of sample XML data. Please see the value highlighted in yellow.


XML sample


Now, since it is straightforward 1 to 1 mapping, the package is not picking up second value 24304 from the XML. The destination table looks like following -


Destination Table


What I want is another row in the destination table with same data except for val which should be 24304. Is it possible to modify this 1 to 1 mapping in SSIS to pull multiple XML values in target table?


No comments:

Post a Comment