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
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
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. ...Error Message: Could not load file or assembly ADODB
Action: When executing an SSIS package with a COZYROC Task and/or component, the following error is encountered. Error Message: "Could not load file or assembly 'ADODB'..." Recently, customers have reported an issue with the ADODB module, which is ...Validation error. CozyRoc File Transfer Task <TASK NAME>: '<CONNECTION MANAGER NAME>' connection is not 'FILE' type.'
Action: When configuring a package using the File Transfer Task, the following error is encountered. Error Message: Validation error. CozyRoc File Transfer Task <TASK NAME>: '<CONNECTION MANAGER NAME>' connection is not 'FILE' type.' Solutions: This ...Error Message: Local path is not a file path or you do not have permission to access it.
Action: When running a package in Visual Studio that is using COZYROC File Transfer Task and a File Connection Manager pointed to Example - E:\Some_Directory, the package runs fine. However, after deploying the package to SQL Server Agent, the ...