error handling in ssis

Question

how i do error handling in ssis

Answer 1

That's simple check this.

---

My Blog    |      Ask Me     |

Answer 2

how we achieve error handling in ssis

Answer 3

Error handling is SSIS can be inbuilt or customized.

1) Inbuilt SSIS has error codes and messages which can be logged in the data flow or throuigh the event handlers.

2) Cutomized error handling through the use of event handlers can be performed as per Jamie's blog http://consultingblogs.emc.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspx

---

Happy to help! Thanks. Regards and good Wishes, Deepak. In a revamp of my Blog!

Answer 4

what is the use of error handling?

Answer 5

what is the use of error handling?

you can use error handling for custom logging, or for any action you want to do based on an event,

for example you want to send an email when one of the tasks in control flow cause error, so you create an OnError event handler, and add a send mail task there. or you want to do a task when a variable value changes, so you can use OnVaraibleValueChanged variable. a sample of custom logging with event handlers is in Deepak's post.

---

http://www.rad.pasfu.com
My Submitted sessions at sqlbits.com