I have a table in SQL Server which holds the filenames and the ftp Connection manager I need to get the files. These files have wildcards in the name. I have a dataflow task, which queries the table in the database. Then a conditional split and a recordset destination, I have a conditional constraint so that I can choose one of 2 ftp connections to use. This links on to a for each loop (for each ADO Enumerator) which uses the recordset destination as the object source. I then map variables to the values in this recordset, one of which is the expected filename (with the wildcards) This feeds into a FTP task which then looks to get the file in question and saves it to a local directory. Now is there a way to capture the name of the file being fetched from the ftp site, or would I have to loop through the destination folder to find the filenames. If I can't use an FTP task then maybe I need to use a script here instead. Any help would be greatly appreciated

You can't get the results of the FTP Task's activities. Your thoughts are right on - you're going to have to query the folder contents after the FTP Task, or use a Script Task to have finer control over the FTP activities. There's a very popular script here. Talk to me now on

Great Thanks Todd.. I wont waste any more time trying to figure out what can't be done. I will probably go via the script route as it seems more effecient .