using SSIS to FTP to a server and pull csv onto another drive
Posted on 2011-02-25
I have a file i want to access, and take the latest csv file saved in that folder.
I can FTP to this server
and in this folder is a list of all the csv files that are saved daily.
if there were only one new file saved there every day, and nothing else in the folder and the same name for this new file, then i can get my package to pick up this folder.
But because every day there is a new file saved and its name will be different every day 'filename_date' , i do not know how to do this.
Can anyone direct me in what to do.
Is there something i can do with the settings on the FTP tool on SSIS.
I'm using SQL SERVER 2005.