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

• monilps

  SSCommitted

  Points: 1686

  More actions

  November 20, 2013 at 10:50 am

  #300679

  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.

• michal.lisinski

  SSCertifiable

  Points: 6933

  More actions

  November 20, 2013 at 1:49 pm

  #1667915

  Hi

  I simply use 7-zip for that:

  Configure Execute Process Task with settings

  Executable: C:\Program Files\7-Zip\7zG.exe

  Arguments: -wc:\TEMP e \\SERVER\share\myfile.tgz

  WorkingDirectory: \\SERVER\share

  Ofc you need to run package on user account with proper permissions to shared folder.

  Sorry, but your next problem is not too clear for me to make a good suggestion.

  Regards

  Mike

• shah.p.vishal

  Newbie

  Points: 6

  More actions

  November 20, 2013 at 2:34 pm

  #1667939

  I think I got what you are saying.

  Thanks.

• Raunak Jhawar

  SSCoach

  Points: 15701

  More actions

  November 29, 2013 at 12:43 am

  #1669766

  If I understand correct, read the file name using a script task and assign the name to a variable.

  Follow this: http://stackoverflow.com/questions/5152671/how-to-load-an-xml-file-into-a-database-using-an-ssis-package

  Raunak J