SSIS Extraction Approach

Question

I have to do extraction of zipped file using SSIS, I could think of two available option 7zip or Script Task using System.IO.Compression.ZipFile.ExtractToDirectory() function.

I need a suggestion which is more efficient approach?

Any other more efficient approach is welcomed.

Answer 1

You can use both methods since they can both solve your issue. But if I was asked to solve a similar issue I will use 7Zip since it is a seperate third party product and it is improved continuously and may have additional functionalities, while System.IO.Compression assembly is a part of a larger framework (.Net Framework) and its improvement are less frequent.

You can use 7zip from an Execute Process Task by passing command line arguments:

• Unzip .tar.gz files in SSIS
• Zip a folder using SSIS
• How do i set password to zip file in SSIS?