SSIS – Read XML file in Script Component as Source

home
database
view story

3 Kicks

SSIS – Read XML file in Script Component as Source(beyondrelational.com)

submitted by sudeep(228) 1 year, 2 months ago

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.

add a comment |category: Database |Views: 33
Tweet