question

BhavinN avatar image
BhavinN asked

Using SSIS package to Zip using Winzip64

I'm very new to both SSIS, Winzip64 (Exprecially this) and batch file or DOS commands. I'm using winzip64 on main SQL DB, it is stored in C:\Program Files\Winzip\Winzip64.exe. I have .csv file on Server2 path "\\Server2\Production\OUT\*.csv". I want to ZIP the file and write it to Server2 "\\Server2\Production\OUT\*.zip". I created a Execute Process Task and and in the **Arguments:** *"C:\Program Files\Winzip\Winzip64.exe."* **\\Server2\Production\OUT\** *-min -a -en "\\Server2\Production\OUT\*.zip" "\\Server2\Production\OUT\File_Exp_*.csv"* --- "*" represents the DataTime Stamp **WorkingDirectory :** *"\\Server2\Production\OUT"* The issue is that the above works when package is run on its own but the process hangs when I add this to step 3 of my SSIS package in SQL Jobs. Can anybody assist with what am I missing? I have tried about everything that could. Appreciate any feed with this issue.
ssis-2008windows-server-2008-r2
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hi - Are your jobs running on a different environment? Is the user running the job having access to the particular server and the Winzip64.exe process? Can you try using the dos application of WinZip (WZZIP.EXE) for cmd-line process execution such as these?
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.