SSIS Ensure a sequence container is not marked as failed if a specific task fails
Have you looked at the Propagate variable for the OnError Event Handler of the task within the sequence?

Check this link for info. Basically, you disable propagation of the OnError event so the ancestor tasks (or sequence in this case) don't receive the error.