1

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.

Hadi
  • 36,233
  • 13
  • 65
  • 124
Bantu11
  • 43
  • 8

1 Answers1

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:

Hadi
  • 36,233
  • 13
  • 65
  • 124
  • @Toshniwal11 please feel free to accept the answer by [clicking on the Mark located on the left side of the answer](https://www.stackoverflow.com/tour) – Hadi Jul 24 '19 at 18:27