Error Message: Could not load file or assembly System.IO.Compression
Action:
When calling this command within my integration package the error message below was encountered:Microsoft.PowerShell.Archive\Expand-Archive -LiteralPath $zipFile -DestinationPath $workDirectory -Verbose
However, it seems to work fine when running as the same user from the powershell command prompt on the same server.
Error Message:
“VERBOSE: Performing the operation "Expand-Archive" on target "C:\work\transcripts.zip". >> TerminatingError(Add-Type): "Could not load file or assembly 'System.IO.Compression' ”.
Solution:
Our developer was able to reproduce the issue and reported that by copying a version of the following DLLs that are targeting .NET 4.5, the issue was resolved successfully.
Put the following DLLs from https://ssisplus.blob.core.windows.net/patches/15964/SysemIOCompressionDLLs.zip in the same folder as ISServer.exe and it should solve the issue (also, registering them in GAC is likely to also work).
Book a Presales Call
Related Articles
Error Message: Could not load file or assembly System.IO.Compression
Action: When calling this command within my integration package the error message below was encountered: Microsoft.PowerShell.Archive\Expand-Archive -LiteralPath $zipFile -DestinationPath $workDirectory -Verbose However, it seems to work fine when ...Error Message: Could not load file or assembly System.IO.Compression
Action: When calling this command within my integration package the error message below was encountered: Microsoft.PowerShell.Archive\Expand-Archive -LiteralPath $zipFile -DestinationPath $workDirectory -Verbose However, it seems to work fine when ...Error Message: Could not load file or assembly System.IO.Compression
Action: When calling this command within my integration package the error message below was encountered: Microsoft.PowerShell.Archive\Expand-Archive -LiteralPath $zipFile -DestinationPath $workDirectory -Verbose However, it seems to work fine when ...Error Message: "Could not load file or assembly 'ADODB, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies”
Action: While using the OLE DB Destination inside of Data Flow Task Plus, the following error is encountered. Error Message: “Could not load file or assembly 'ADODB, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its ...Error Message: 0xC0029183 at <TASK NAME> from <FOLDER NAME>, File Transfer Task: File represented by "/output" does not exist.
Action: When executing an SSIS package with the File Transfer Task, the following error is encountered. Error Message: 0xC0029183 at <TASK NAME> from <FOLDER NAME>, File Transfer Task: File represented by "/output" does not exist. ...