question

Noonies avatar image
Noonies 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.
ssis
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sqlaj 1 avatar image sqlaj 1 commented ·
Are you getting errors? Maybe a permissions issue related to running as yourself then through SSIS? I would look in that direction similar to how SQL Agent executes under a user.
0 Likes 0 ·
Noonies avatar image Noonies commented ·
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.
0 Likes 0 ·

1 Answer

·
Noonies avatar image
Noonies answered
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.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.