'SSIS - For each loop not stopping
I make For Each Loop container to store file name (from directory) to SQL table. It works fine until i put it inside Execute Task.
My problem is, after put it inside Execute Task, the For Each Loop container run forever (non stop loop) and it is not going to the next process.
Below is the For Each Loop Container and I put it inside the execute package task on picture 2
I use variable in For Each Loop to store the files directory and insert it on table using Execute SQL Task

Is there some setting or properties need to set?
Thanks
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|

