The Integration Service uses the following rules to evaluate error breakpoints:
The Integration Service encounters a null input value, and the port contains a user-defined default value of ERROR ( ).
The Integration Service encounters an output transformation error, and the port contains the system default value of ERROR ( ). The following errors are considered transformation errors:
Data conversion errors, such as passing a string to date
Expression evaluation errors, such as dividing by zero
Calls to the ERROR function in an expression
The Integration Service encounters a null input value or transformation output error, and the port contains a user-defined default value of ABORT ( ).
The Integration Service encounters a fatal error.
If the Integration Service encounters an error when it processes a transformation, it evaluates error breakpoints for that transformation and global error breakpoints. If any error breakpoint evaluates to true, the Debugger pauses and does not evaluate data breakpoints.
When the Integration Service encounters a fatal error or an ABORT, the Debugger breaks even if it has not reached the configured number of errors to skip.