Error Handling

Question

Hi All,

I want to know how to do error handling and some options available and regularly used across the industry:-

* If the package fails to start -> Does it write error in any table or somewhere, we can pick it up from?

** Inside the package - Whats the best strategy to write logs for failed file conversion.. in our case we are reading 70 excel files and putting it at a target location by converting them to txt file?

Cheers.

Answer 1

1.Set up the SSIS Logging.
   It will log errors to a DB table.

2. Inside the package based on ur condition that if the records have error you fail the package(this is not an Error for SSIS but for you) for this u need to use Script task to log the error urself to what ever palce you wish to. I would use script task to log the error to a file and at the end of the package use Send Mail Task to send mail with the file as attachment to the concerned people.

---

Hope this helps !!
Sudeep   |    My Blog

Answer 2

Thanks Sudeep,

Please elaborate (How do I do this?) a little on the first point please.

Thanks in advance.

Answer 3

For logging in SSIS:
http://msdn.microsoft.com/en-us/library/ms167456.aspx

---

Nitesh Rai- Please mark the post as answered if it answers your question

Answer 4

Sorry I proposed as answer by mistake.

Which do you want elaboration?

---

Hope this helps !!
Sudeep   |    My Blog