SSIS task failed event handler [duplicate]

This question alre开发者_如何学运维ady has answers here: SSIS send email on error sending multiple errors (5 answers) Closed 8 years ago.

Is there any way in SSIS to identify which particular task has failed? My requirement is on file source task failure I need to send an email.

---

In your error handler, you can use the System::SourceName variable to pull the name of the task it was on when it failed. I do this in an email task to the production support team. Or you could put it in a table if you wanted to.

---

Your log should be able to tell you which task failed and (in most cases) why it failed as well.

You can add an OnError Event Handler to handle failure gracefully as well.

---

I use the following variables in error handling In the email task:

System::SourceName

System::ErrorCode

(DT_WSTR, 4000) @[System::ErrorDescription]