Executing Command Prompt commands in SSIS
Execute Process Task is used to execute the external application in SSIS.
If you need to execute a command line commands such as DIR, COPY, DEL, RENAME, etc. then you have to use cmd.exe command that is located in c:\windows\system32\
CMD.exe requires an additional argument “/C” while executing command line commands in Execute Process Task. Otherwise, It will not execute the given command.