[SOLVED] SSIS - 2nd Script Task not being executed in Foreach Loop Container

SSIS - 2nd Script Task not being executed in Foreach Loop Container

I have 2 script tasks in my foreach loop container in an SSIS package. See picture. The first script task Determine which file is presented gets executed just fine. However, the second one Archive Broker File does not get executed at all.

I can see in the progress that the script tasks gets validated but no execution at all. The only thing it needs to do is to rename a file and move it to a different location.

Any idea what's going on especially since the first script task gets executed without any issues.

Thanks, Daniel

Solution

Cause

It will not be executed if the three data flow tasks are not executed since you are using precedence constraints (link between tasks) with Logical AND condition

Solution

Double click on any precedence constraint going from any Data Flow Task to the script Task and change the condition to Logical OR

Info from official documentation

Based on Precedence Constraints official documentation:

Logical AND
Select to specify that multiple precedence constraints on the same executable must be evaluated together. All constraints must evaluate to True.

This type of precedence constraint appears as a solid green, highlighted or blue line.

Logical OR
Select to specify that multiple precedence constraints on the same executable must be evaluated together. At least one constraint must evaluate to True.

This type of precedence constraint appears as a dotted green, highlighted, or blue line.

Other helpful articles

You can read more about precedence constraints in the following article: