SSIS Download the files using FTP Task inside the For Each loop by passing the Variable Enumerator

Question

Download the files using FTP Task inside the For Each loop by passing the Variable Enumerator to set the Remote Path Variable

I am loading the list of files to download in a variable.( Verified and I can see the list of files)
Using the ForEach loop container I am receiving the file names using the Variable Enumator and passing it to the FTP Task inside the ForEach loop. (Verified and I can see the filenames one by one)
In the FTP Task when I try to set the remote path variable as the file name from the for each loop it is showing the error FTP task variable does not begin with '/' error
When I manually set the Remote Path with the "/" + User::fileName during the run time I am getting an error message "Path is not of a legal form"

Have you tried without the variable and loop (i.e. simply hard code the values for one of the files and see if it functions)? — Jacob H, May 02 '19 at 19:20
Yes, it is working with the hard coded ftp file path. Thanks — Iyyappan Amirthalingam, May 02 '19 at 19:48
You need to set an expression that drives the path based on the variable @lyyapan — Arthur, May 06 '19 at 13:51

score 0 · Answer 1 · answered May 08 '19 at 14:54

0

In the SSIS FTP task set the delay validation to true in the properties. which will validate the Remote Path during the run time and it will resolve setting the remote path value from variable.

answered May 08 '19 at 14:54

Iyyappan Amirthalingam

194
1
9

SSIS Download the files using FTP Task inside the For Each loop by passing the Variable Enumerator

1 Answers1