Debugging & Error Handling with SSIS 

Error Handling

Package development and implementation goes beyond use transformations to connect sources to destinations. You must also execute error handling, test and troubleshoot your packages as you develop them.  SSIS provides several ways to handle errors at different levels of the SSIS architecture. For example, at the control flow level, you can add a defeat constraint that. If an error arises, redirects the workflow to a specified alternate task. Likewise, in the data flow, if a row causes an error in a transformation, you can send the row out an error way. SSIS even involve event handle capabilities that let trap On Warn and Error events. SSIS's various capabilities for debugging packages during development. For dealing with errors production execution. We will begin by look at the way to configure package transactions and checkpoints. Then we will see how to identify package rank and handle task errors. We will complete by cover data flow error handling and debug.

Debugging Packages during Development

SSIS is far ahead of DTS in the area of debug. Which is the process of identify errors that prevent a package. From be executed or produce the desired results. Debugging involves using MsgBox statements. The VBScript Stop command to simulate a breakpoint in scripts. Such statements had to delete from the package before put into production. In contrast, debug is build into SSIS, and nothing has to delete. When the package is move to a production environment. The problem with SSIS’s debug tools is that they aren’t consistent. Across all types of tasks, so know when to use what tools can be a large help. Let’s look at SSIS’s debug capabilities at the package level. Followed by debug within Control Flow tasks and Data Flow tasks.

Debugging Control Flow Tasks

Control Flow tasks control the flow of the package. SSIS is debugging tools for Control Flow tasks close resemble. Those available in any respectable development environment. Breakpoints and the Debug windows can be especially needful in debug Control Flow tasks. Breakpoints tell SSIS to pause execution at the indicated point in the package. When process encounters a breakpoint in Debug mode, process pauses. The Debug windows access to such as variable values, call stacks, and status messages. You can set breakpoints at the package, container, task, or Script task elevation. Breakpoints to pause after a given number of encounters with an event. Such as on the tenth iteration of a task in a For Loop construct. Capabilities that let trap On Warning and Error events. SSIS's various capabilities for debug packages development. For deal with errors during production execution. We will begin by look at the way to configure package transactions and checkpoints.

MSBI Online Training Course

Then we will see how to identify package rank and handle task errors. We will complete by cover data flow error handling and debugging.