I need to compress a data folder in SSIS.
For that, I use a Script task which runs this script :

```
public void Main()
        {
            // TODO: Add your code here

            try
            {
                string zipPath = (string)Dts.Variables["User::sFolderCompressed"].Value;
                string startPath = (string)Dts.Variables["User::sFolderSource"].Value;

                ZipFile.CreateFromDirectory(startPath, zipPath);
            }
            catch (Exception objException)
            {
                Dts.TaskResult = (int)ScriptResults.Failure;
                // Log the exception
            }
            Dts.TaskResult = (int)ScriptResults.Success;
        }

```

The 2 variables I have set up:

[![enter image description here](https://i.stack.imgur.com/cQzAI.png)](https://i.stack.imgur.com/cQzAI.png)

Executing the Script Task step gives me the following error:

> 
> {System.DllNotFoundException: Unable to load DLL 'clrcompression.dll':
> The specified module could not be found. (Exception from HRESULT:
> 0x8007007E) at Interop.inflateInit2\_(Byte\* stream, Int32
> windowBits, Byte\* version, Int32 stream\_size) at
> System.IO.Compression.ZipFile.Open(String archiveFileName,
> ZipArchiveMode mode, Encoding entryNameEncoding) at
> System.IO.Compression.ZipFile.DoCreateFromDirectory(String
> sourceDirectoryName, String destinationArchiveFileName, Nullable`1
> compressionLevel, Boolean includeBaseDirectory, Encoding
> entryNameEncoding) at
> System.IO.Compression.ZipFile.CreateFromDirectory(String
> sourceDirectoryName, String destinationArchiveFileName) at
> ST\_19ce97c462f844559ec30884173f5a28.ScriptMain.Main() in
> c:\Users\SQL\AppData\Local\Temp\3\Vsta\46892b1db29f45f2a8e1fb8c5d37a542\ScriptMain.cs:line
> 104}
> 
> 
> 

Error message is pretty clear that I am missing a 'clrcompression.dll' file somewhere.
Can I just download this DLL? and where do I copy it to?

**UPDATE**

Added 'Execute Process Task' and set the following:

```
Executable : 'powershell.exe'  
Arguments : -nologo -noprofile
    -command "Compress-Archive -Path E:\Flat Files\IT\StockAge\Stock Age Difference\MAINCHECKK807Babbage\BabbageStockAgeingPartno.csv
    -DestinationPath E:\Flat Files\IT\StockAge\Stock Age Difference\MAINCHECKK807Babbage\BabbageStockAgeingPartno.zip"

```

But getting error:

> 
> [Execute Process Task] Error: In Executing "powershell.exe" "-nologo
> -noprofile -command "Compress-Archive -Path E:\Flat Files\IT\StockAge\Stock Age
> Difference\MAINCHECKK807Babbage\BabbageStockAgeingPartno.csv
> -DestinationPath E:\Flat Files\IT\StockAge\Stock Age Difference\MAINCHECKK807Babbage\BabbageStockAgeingPartno.zip"" at "",
> The process exit code was "1" while the expected was "0".
> 
> 
> 

**UPDATE 2**

Executing the script in PowerShell gives me the following error.

[![enter image description here](https://i.stack.imgur.com/5aKTd.png)](https://i.stack.imgur.com/5aKTd.png)