2

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

Archive Broker File not being executed

Improve this question

1 Answer 1

Reset to default
2

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:

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.