Hi I have used Winzip32.exe in my application to unzip files from certain location to a certain location.I have used
winzip32.exe -min -e options to unzip.
I have made my application to run as a process task in SSIS package with few other steps and scheduled the job to run weekly thorugh Sql server Agent jobs.
Issue is,when i run the whole ssis package from Sql business intelligence studio it runs normally but when the schedule runs from sql job it hangs up .The reason is when the .net application runs the shell command to unzip files using WinZip32.exe it opens a window to show the extracted information.But when this application runs through a sql job it can't open this window and just hanging up.
IS there any solution to avoid this happening.
...
Go to the complete details ...