How do I capture errors in SSIS package?
How do I capture errors in SSIS package? Too easy.Left-Click (highlight) on the object you want to capture the error event (Script, or Data Flow, etc.)Click on 'Event Handlers' - screen should open with Executable = object you clicked and Event Handler = OnError.Click URL (click here to create....)Drag Execute SQL object from SSIS Toolbox. What are best practices for error handling in stored procedures? Best Practices for Error Handling in Database Stored ProceduresInclude an exception handler for every logical grouping of PL/SQL statements (BEGIN/END block). Log everything, especially exceptions. How does SSIS handle data conversion error? Step 1: Drag...