Unzip .gz file from network map drive and load into table (SQL 2012)

• monilps

  SSCommitted

  Points: 1686

  More actions

  November 20, 2013 at 10:53 am

  #280397

  Hi,

  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.