We are facing few issues running the batch command to initiate the ws_ftp process .I am using execute process task to trigger the batch file.
We are executing below batch command
"C:\Program Files (x86)\Ipswitch\WS_FTP 12\wsftppro.exe" -s local:\\ftp001\*.csv -d My_Supply:/usr/local/
Above command works fine when I call it using a sql job (Using management studio) and ssis proxy user is remotely connected to the server.
Once the proxy user is logedoff of the serve the command would return process exit code 3 and fail. Job fails basically.
I would like to know if you are aware of any special privileges the account that executes this command should have so that it can execute without being physically logged in to the machine.
Any help is greatly appreciated.