download latest files from winscp(SFTP) in ssis

Question

I need some help to identify the Latest file from multiple files with different data time stamp like below in winscp(SFTP). I want to download those latest files to my local folder using execute process task in ssis.

1. Timetravel_13-07-2023_06-30-00.csv
2. Timetravel_12-07-2023_18-30-00.csv
3. Orgs_13-07-2023_06-30-05.csv
4. Allop_13-07-2023_06-30-00.csv
5. Allop_11-07-2023_18-30-01.csv

I want 3 below files from above list like

Timetravel_13-07-2023_06-30-00.csv

Orgs_13-07-2023_06-30-05.csv

Allop_13-07-2023_06-30-00.csv

Could some one help on this will be gr8 help.

Answer 1

Hi @Roopa Tata,

You may download all the files from winscp(SFTP) first and then use C# to get the latest files.

Check: https://bageshkumarbagi-msbi.blogspot.com/2019/09/load-latest-file-into-database-using.html

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Hi @Roopa Tata,

WinSCP provides an excellent support for SSIS.

Check it out here, directly on the WinSCP site:

• Using WinSCP .NET Assembly from SQL Server Integration: Services (SSIS)https://winscp.net/eng/docs/library_ssis
• SFTP file transfer task for SSIS using WinSCP scripting:
  https://winscp.net/eng/docs/guide_ssis