CODEWITHSUNDEEP
sql-serverssisetlsql-server-data-tools
Mike Eale
Mike Eale

Reputation: 121

How two precedence constraints from different task can goto one task in SSIS

Please I need help regarding how to resolve two precedence constraint merge to one task. The issue is that the script task check for csv file, if exist run the next task and if it doesn't exist goto the next script task and check if zip file exist, if exist run unzip task then run the loop. If I run the package when csv file do not exist, the zip file check runs and unzip runs and the task stop at in zip but refuse to run the loop. but if csv file exist it ran. How can I resolve the precedent constraint to work when the unzip task execute to run loop.

Upvotes: 2

Views: 515

Answers (1)

Hadi
Hadi

Reputation: 37358

Just click on one of the precedence constraints linked to the Task you want to execute and check the Logical Or option.

enter image description here

Upvotes: 3

Related Questions