Receive multiple FTP files

Is there a way to get more than one file with a single ftp task in SQL 2005?

I need to get 5 files from one server. They are in two different directories is that makes any difference. Right now I have a separate task for each but would like to have one task if possible.

Thanks

You can use a wild card (*) in your path... If you can't use a wild card to get your 5 files, then you'll have to split up the tasks.|||

I figured something like that would be the answer...

Thats ok though... Thanks for the response.

|||

Bill, we actually use a table for our connection (directories, files, etc.) for FTP's and loop through the table replacing the FTP properties (in the FTP task) with the info from the table. If you did this, you could read the connection info into a recordset. Add a ForEach task and place the FTP task within the ForEach container.

The recordset info then drives the connection info for the FTP task... Since you mention two directories, you could use a row for each directory. Lots cleaner (and easier to maintain!) than having five separate FTP tasks firing...

sql