SSIS – Read XML file in Script Component as Source

For a long time I was planning to write on this topic. So here I am. I take a example of reading XML file in Script component as source. I am using XML Document to read the XML file in my case. In case your file size is huge I would recommend you use XML Reader. I find XML Document simpler to code :). In order to use XML Document you would need to know a bit of XPATH to read the XML file. Ok so now we start on the actual file extraction.