September 5, 2019 at 8:19 pm
I am using Visual Studio 2010 on SQL Server 2012. I have an Execute Process Task which runs w/o error, but does nothing. When I run from command line, it works fine. The process, which deletes files in a folder older than specified number of days, works in other projects. Executable property is set to "C:\Windows\System32\cmd.exe" and the arguments property is set to:
"Forfiles -P I:\Solutions\Suppliers\Archive /M *.csv -D -1 /C "cmd /c del /q @FILE""
Note that I've placed double quotes around both arguments shown here, the only double quotes in the arguments are around "cmd /c del /q @FILE". I have compared properties of working and non-working Execute Process Task and other than folders and number of days, they are identical.
September 6, 2019 at 9:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
September 7, 2019 at 4:27 pm
You've probably already checked this but if the other tasks are deleting from other folders then could it be a difference in permissions? Either on the folder itself or the permissions that the execute task is using? Running from a command line might be using different permissions, possibly an administrator account.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply