exit the package conditionally

I'm inside a "dataflow" and

i have a conditional spliter

one of the condition say "ok"

and the the other says "not ok"

when my flow goes to the "not ok" condition

I want to Abort the entire package execution

I want to make it sure that the package is terminated

and could not triggers the next control in the control flow.

i want to kill/ abort the execution of all my SSIS processes

for the entire package within the current dataflow

The data flow is not the place to give the stop & go to the package execution flow. For that you should use the control flow and put some conditional logic in the precedence constraints.

If you want to abort the package execution because there is at least one row identified as 'not ok'; you could use a execute sql task to run a query (assuming your source is a table, but a simialr approach can be used for files) to check that condition and populated a variable with the result (0/1 r stop/go,etc) then use that variable in the precedence constraints to achieve the desire behavior

|||As Rafael Salas said you can use precedence constraint and there you can specify the