etl - Unzip .tar.gz files in SSIS

Question

I have a .tar.gz file. Now i need to unpack these files with SSIS package. Previously did unzip and delete for .zip files with the help of For each container and script task. Not sure how to do it for .tar.gz files. Any help?

Answer 1

You can use an execute process task to achieve this (or using process from Script task), but you have to install a ZIP application like 7Zip or Winzip or else. And use command line to Zip or Unzip archives.

Follow one of these links for more details:

• Zip a folder using SSIS
• 7Zip command line examples
• What command line parameters does WinZip support?