Hi everyone! I created a Execute Process Task in SSIS to run a cmd file which is set to extract a .gz file using gunzip.exe in the location provided within the cmd file. When I run the file from my computer or the server the file is extracted. But when I run this within the Execute Process Task it shows succeeded but the file is never extracted. The Executable in the under Process in the Editor is pointing to my file location and file name. I have used mapped drive and defined UNC path with the file name and nothing happens. Am I missing some configuration on my end that needs to be done? Or does anyone have a suggestion or link that could point me in the right direction to resolve this? Greatly appreciated.
I reviewed some Microsoft links on Execute Process Task and found some verbiage on WorkingDirectory. I was following some other blogs and examples on how others had written there task and no mentione of WorkingDirectory was needed. I placed the Executable to the mapped drive including file name and workingdirectory to the mapped location of where the file resides. This resolved my issue.