WinSCP SSIS Task not getting file on first try.
Version 5.8.1 beta (Build 6144).
Issue: I built an SSIS Process Task which called launched WINSCP.exe with an argument:
open ftp://fs_kbb_yieldex:Cft24J5EGZIdUA%3D%3D@ftp.operativeone.com/
Option exclude */
get -latest /*.tar.gz"
exit
The package has been running perfect until about a week ago. Now when I execute the task, it does not retrieve the latest file, but the SSIS task completes although it was successful.
What I find interesting is that if I launch WinSCP application and connect to the same FTP site, I see the file I need there.
So at this point when I go back to SSIS and execute the task, it works this time around and starts to pull the file down.
Is this related to the version I recently upgraded to?
Thanks
tannercortes@gmail.com
Issue: I built an SSIS Process Task which called launched WINSCP.exe with an argument:
open ftp://fs_kbb_yieldex:Cft24J5EGZIdUA%3D%3D@ftp.operativeone.com/
Option exclude */
get -latest /*.tar.gz"
exit
The package has been running perfect until about a week ago. Now when I execute the task, it does not retrieve the latest file, but the SSIS task completes although it was successful.
What I find interesting is that if I launch WinSCP application and connect to the same FTP site, I see the file I need there.
So at this point when I go back to SSIS and execute the task, it works this time around and starts to pull the file down.
Is this related to the version I recently upgraded to?
Thanks
tannercortes@gmail.com