CODEWITHSUNDEEP
sql-serverssis7zipsql-server-agent
DDJE
DDJE

Reputation: 1

SSIS Package with 7-zip exe not working in SQL Server Agent

I created a SSIS package to extract zip files (which contains Csv files) using 7-zip then uploads the data into SQL Server. When I run it in Visual Studio, it worked perfectly, but when I run the job in SQL Server Agent, I get this message:

The process exit code was "2" while the expected was "0"

I tried the following to resolve the issue but no luck:

  1. Changed the SSIS 7-zip file location to: C:\Program Files (x86)\7-Zip
  2. I placed the 7-zip exe folder in the location where my zip files are located.
  3. I used the hyperlink where the 7-zip is located
  4. I used the mapped drive link where the 7-zip is located
  5. I am logged in as an admin (both SSMS and SSIS) so permission is not an issue.

For item #3 above - the job says it was successful but it didn't extract the zip files.

SSIS Execute Process Task

Executable: Z:\ZIP_Files\7-Zip\7z.exe or \\nas\PIND\VAULTSAMPLES\datasamples01\Medina OH\Recorder Data\Historical\ZIP_Files\7-Zip\7z.exe (I tried both)

Arguments: E "\\nas\PIND\VAULTSAMPLES\datasamples01\Medina OH\Recorder Data\Historical\ZIP_Files" -y

Working Directory: \\nas\PIND\VAULTSAMPLES\datasamples01\Medina OH\Recorder Data\Historical\ZIP_Extraction

Upvotes: 0

Views: 240

Answers (0)

Related Questions