Capture sucsess/failure

Question

Hi All,

I have a sequence container that contains two execute SQL tasks and on data flow task. If this process fails, I want to log the details in a table. Any idea how to capture the success/failure of the sequence container? Also, is there a way we can capture the error as well? Please advise and thank in advance.

Answer 1

Use an Event handler for this sequence container. The error description is not often too helpful.

A link to a blog post outlining how to achieve the desired: http://sqlblog.com/blogs/rushabh_mehta/archive/2008/04/24/gracefully-handing-task-error-in-ssis-package.aspx

---

Arthur My Blog

Answer 2

And one more, perhaps better post to examine as a possible solution: http://www.simple-talk.com/sql/ssis/ssis-event-handlers-basics/

---

Arthur My Blog

Answer 3

The easiest thing to do is to connect the sequence container to an execute SQL task via a precedence constraint such that you can log whatever you want to a database.  You can have two; one for failure and one for success.

---

Phil Brammer | http://www.ssistalk.com | Twitter: http://twitter.com/PhilBrammer