SSIS Error handling : Events vs control flow?
-
I have built a few SSIS packages over the years, most of which contain a design which will fit within the VS window with little scrolling (i.e. not hugely complex). Although I have largely got my head round logging and configuration, I have never really fully settled on a standard for error handling. I often handle errors via control flow (i.e. the red connectors) but have dabbled once or twice with the event handlers. While I have got the latter to work the implementation of them never seemed quite right (apologies for vagueness). Does anyone have any thoughts on, or real world experience of, which route is better? ...or does it depend on the nature of the error? i.e. data-related errors via flow but critical failures via handlers. Hoping this is not another one of those bun-fight topics...