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.
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?
17 People are following this question.
