We receive multiple XML files (a.xml, b.xml, c.xml etc) from a vendor on a daily basis. These files have the same structure and I want to create an SSIS package that combines all these files and merge them to one single XML file (with naming convention FileName_sysdate.xml) on a daily basis.
I tried using XML task with Merge (Operation Type) but that only worked if you have 2 files. What other options do I have?
Thanks in advance.