I have a SSIS package, which executes a winscp script. On a remote server i have two folders and on under folder (PartyCodes) i have a .csv file (codes.csv) that i need to copy to local drive and delete the file.
I have the following script which runs but doesn't copies the file, please advice where am going wrong.
NOTE: When i executed the package first i got the following error ([Execute Process Task] Error: In Executing "C:\Program Files (x86)\WinSCP\WinSCP.com" "-script=C:\winsftpscriptCAR.txt" at "C:\Program Files (x86)\WinSCP", The process exit code was "1" while the expected was "0".0. So changed the task properties (FailTaskIfReturncodeisnotcorrectvalue to FALSE).
Now the job is success but not copying the files , my code
option batch on option confirm off open sftp://userid:pwd@servername:22 -hostkey="ssh-rsa 2048 xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx" cd . option transfer binary get -preservetime *.csv F:\FTPShare\ftp\CARDownloads\ close exit