I am working on SSIS, my question is I want to write a SSIS package to parse XML file and the output should store in the database.what I did in the image 1 and in this package, I haven't written any code for parsing and in the output I am getting g only the header values from XML file but I need to read the data which is the each header too.actual output should be like:metername ,serial number,meterreadingid,medaitype,installdate and i am attaching the xml file can anyone help me on this please,

XML FILE IS HERE:
-
-
+
-
-
+
-
Replies
Know the answer? Post it — somebody with the same question will find it here.