I've existing SSIS package which is loading Inbound file and SP to validate the data. If data has error then that task is failing by raising errors and user is being notified to correct the data. Task failing is causing package failing also. If there is a task failed due to data error, I want to stop the package execution and success package. How can I set this in existing SSIS package?

There are several options, but in your case the most applicable seems to be in forcing the ExecutionResult of the data load task by selecting a value for the ForceExecutionResult property to 0 means Success or 2 Completion.

Can't you make use of the Completion precedence constraint on the task and pass the control to the subsequent tasks?

Hi kevin732,

According to your description, if there is a task failed due to data error, you want to stop the package execution but success package.

As Arthur said, we can make use of the ForceExecutionResult package property. It controls the execution result of the package, force a specific execution result. So please change this property to Success to achieve your requirement.

For more details about ForceExecutionResult property, please see:
https://msdn.microsoft.com/en-us/library/ms137749.aspx
https://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.dtsforcedexecresult(v=sql.120).aspx

Thanks,
Katherine Xiong