How to upload mutiple files by FTP task in SSIS

Question

Hi,

I like to upload multiple files, with different names, in a single FTP task to server in SSIS package. I am only able to upload one file.

the file names are also different e.g

xyz, zbc, ced

is there any way to upload multiple file in a FTP task in SSIS.

Thanks

Answer 1

Put all the files in the same folder. Use FTP task inside a ForEachLoop and update the connection string using an expression updated by the loop container. That will do the trick.