November 24, 2010 at 2:01 pm
In my SSIS package, I am trying to send a number of files that all have the *.sbi extension to a FTP site. I opened a ForEach container and placed a FTP Task inside it. When I ran the FTP container by itself by right clicking it and selecting "Execute Container" (since there are test *.sbi files in the location already) the container runs, but the FTP Task inside it doesn't.
Does this mean that the FTP task is not actually INSIDE the ForEach loop even although graphically it is placed inside of the container? how do I send the multiple files from my folder to the remote FTP location?
When I run the task from the beginning, and have a Breakpoint on the FTP Task inside the ForEach loop, I can see that the first file in the folder is successfully picked up by the User::FileWeJustFound variable attached to the ForEach loop, but I get an error when that same variable is used to pass the file to the FTP Task.
I really think that the FTP Task is not inside the loop... I can see the first file in the FTP site, but not the rest. It fails with the message that it can't find the file specified, and I realize that the User::FileWeJustFound variable does not update to show the second file in the folder. HELP!
November 24, 2010 at 4:15 pm
Have you set the expression on the FTP container to dynamically select the appropriate file from the next file in the ForEach loop? Try creating a variable on the control flow, now the ForEach Container, and set it equal to the file path from the ForEach loop. Then with every loop, set the FTP to use the filepath from the variable.
November 24, 2010 at 5:03 pm
Will try it in the morning and report back! 😀
November 25, 2010 at 5:07 am
The FTP Task didn't seem to be inside the ForEach container. Once I deleted it and recreated it inside the ForEach container it worked like a charm. :w00t:
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply