You can create ISNULL and ISDEFAULT conditions in transformation and global data breakpoints. When you use the ISNULL or ISDEFAULT operator, you cannot use the type or value in the condition.
When you create an ISNULL condition, the Debugger pauses when the Integration Service encounters a null input value, and the port contains the system default value.
When you create an ISDEFAULT condition, the Debugger pauses in the following circumstances:
The Integration Service encounters an output transformation error, and the port contains a user-defined default value of a constant value or constant expression.
The Integration Service encounters a null input value, and the port contains a user-defined default value of a constant value or constant expression.
ASK INFAPreview
