Geek Answers Handbook

How to upload mutiple files via FTP in SSIS

I like to upload multiple files with different names in the same FTP task to the server in the SSIS package. I can upload only one file.

file names also differ for example

xyz, zbc, ced

Is there a way to upload multiple files to an FTP task in SSIS.

thanks

+6
file-upload ftp ssis
source share
2 answers

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

+4
source share

just stumbled upon this, and that is exactly what I was looking for. clarify Fayz's answers:

  • create a Foreach pipeline container
  • edit the "Collection" in the Foreach loop container
  • set "Enumerator" to "Foreach File Browser"
  • select the folder you want to check.
  • set "Files" to ".". or any lookup filter you want
  • Select "Fully Qualified" as "Get File Name"
  • click "Mapping Variables" and create a variable with the name you would like
  • delete the "FTP task" inside the container.
  • create "FtpConnection"
  • click "File Transfer" and set "IsLocalPathVariable" to "True"
  • select a new variable in the "LocalVariable" section
  • set "Operation" to "Send Files"
  • set any remote options you want

What is it! The variable will automatically update itself with the full path + name of each file found and then load it.

+4
source share

More articles:


All Articles