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.
 
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.
 
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 -
 
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