bugg (8/28/2015)

---

Stephen Beaven-479566 (6/17/2010)

---

I have a SSIS package running on 2 of our live servers (Windows Server 2003 Enterprise x64 Edition SP2) which creates an excel spreadsheet and then compresses it using rar.

This works fine on one of the servers, but fails on the other.

For some reason the rar file cannot be opened and claims it's corrupt (even when I open it on the server where it was created). I can see the file within it, but can't open it.

The error is:

! D:\blahblahblah\foo.rar: The file "???" header is corrupt

FYI The excel file which is to supposed to be added to the rar file is created successfully and can be opened without a problem - it's only once it's been added to the archive that I get a problem.

The rar file is created by using a Process Task. If I take the values from the task and manually execute them from either the command prompt or using xp_cmdshell the rar file is successfully created and can be opened.

Both the corrupt version of the file and broken version report to be the same size.

Does anyone have any ideas?

As a work around I could change the package to execute a SQL task instead, but I'm reluctant to do this at the moment as I know it's working on one server.

Hi, i know this is an old post but I'm getting them same issue did you ever find a solution to this?

Works fine in VS locally but after deploying to a server get this issue. Happens with both winRar and 7zip for me.