svs1919
asked on
SSIS Loops
I am working on a SSIS package where we are using a 3 rd party tool to connect to secured(Banking) FTP site and downloading one file at a time by passing a input variable. I am generating the variable value through a SQL task. As long as i keep passing a value other than 0 I have to keep looping and executing the 3party component.
How can I accomplish this? whats the best way.. should I use forLoop or For each Loop? Can you please let me know how I can accomplish this. Fyi.. I am not good at script tasks, it would good if can use any other transformations other than Script tasks
How can I accomplish this? whats the best way.. should I use forLoop or For each Loop? Can you please let me know how I can accomplish this. Fyi.. I am not good at script tasks, it would good if can use any other transformations other than Script tasks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.