I am trying to execute an SSIS package and after it starts the execution, it is having an error in data flow source.
There is a lookup in the same data flow task, and although there is an error in the execution, the lookup transformation is keep on executing, and the package is stuck.
The package execution is not stopping and it keeps on executing indefinitely, even though there is an error.
The data flow task looks like the below:
I have also tried enabling 'FailPackageOnFailure' and 'FailParentOnFailure', but the package execution still does not stop after the 'flat file source' has an error.
Please let me know if there is anyway to stop the execution after the error.
Thanks in Advance.