When I run a package including the ZIP Task Component, I get the following error:
[Zip Task] Error: An error occurred with the following error message: "size was 0, but I expected 25500".
A possible reason for this error is that the ZIP Task was trying to zip a folder with an open spreadsheet. Excel 365 locks spreadsheets when they are open. To solve the issue please close all opened files/spreadsheets and then run the package again.
Other possible reasons for the error could be:
- Collision could be happening if a previous zip task is still executing while another zip task starts zipping to same file- if zip of directory is writing to file in its own directory