The aim of this exercise is to
- unzip the xml file (*.xml.gz file) from network map drive
- load into table (xml file) in xml column with name of the file in different column.
Can you please tell me what SSIS tools I can use to achieve this or some sample packages I can refer to.
Thanks for your help in advance.