My SSIS package has a Execute Process Task to unzip a file using WinZip
This process has the following Executable:
E:\Program Files (x86)\WinZip\WINZIP32.EXE
Arguments:
e -o -j E:\bi_loader_drop\myfile.zip E:\mydirectory
This process has worked for years, now it hangs up. When I run the package in debug mode, the WinZip dialog box pops up when the Execute Process Task runs. When the package runs as a job, I think the dialog box causes the package to stop running. I have tried WindowStyle "Hidden" and that does not work.
Does anyone know a way to get this pop up window to stop when the Execute Process Task runs? Modifying the package to use 7zip is not a very good option for me. I don't have the version of Visual Studio right now to make a modification and there are several packages with this problem.
I tried running a PowerShell script to close any Winzip dialog box while the Agent job was running and that did not work either. Does anyone know of a registry setting or some way to get this window to not stop my SSIS package from running?
I am trying to accomplish this through a modification to Winzip or the server, not a modification to the SSIS package.
This process has the following Executable:
E:\Program Files (x86)\WinZip\WINZIP32.EXE
Arguments:
e -o -j E:\bi_loader_drop\myfile.zip E:\mydirectory
This process has worked for years, now it hangs up. When I run the package in debug mode, the WinZip dialog box pops up when the Execute Process Task runs. When the package runs as a job, I think the dialog box causes the package to stop running. I have tried WindowStyle "Hidden" and that does not work.
Does anyone know a way to get this pop up window to stop when the Execute Process Task runs? Modifying the package to use 7zip is not a very good option for me. I don't have the version of Visual Studio right now to make a modification and there are several packages with this problem.
I tried running a PowerShell script to close any Winzip dialog box while the Agent job was running and that did not work either. Does anyone know of a registry setting or some way to get this window to not stop my SSIS package from running?
I am trying to accomplish this through a modification to Winzip or the server, not a modification to the SSIS package.