1. Loop thru table rows which contain folder names, full paths to files and store that path into a variable 2. In a ForEach Loop, FTP each file in that folder (this is already working but only for a hard-coded folder path)
Go back and read the next row to get the next folder name.
I'm looking for ways of adding the Outer Loop for Step 1.
Not sure what the problem is. Have a look at the for each item container. That allows a table as a source and place it in a variable. Create a variable as a system object. Create an execute sql task to get the full resultset from the table - just select the name. Under resultset set the resultset name to 0 and the variable to the one you have created. That will populate the variable with the resultset. Now create a for each loop with collection ADO enumerator and your object variable. Set the variable mapping to a string variable to get each value in turn.
That should give you a loop for each entry in the table. I would then consider calling another package with that info to do the FTP using a variable with the path but that's up to you.
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.