asked
Execute Process Task to run CMD file
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.
No errors. I moved the files locally to SQL Server and ran a test and shows successful but no file extraction. I ran the CMD file on the server to ensure it extracts the file and it does. But when I run in the Execute Process Task, shows successful but no extraction. I verified SSIS domain account is Admin of the server. I will log in in a bit as the service account running SSIS to see if I can errors shortly.
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.
15 People are following this question.
