DTSBreakpointHitTest Enumeration
Enumerates the values for the hit count types. This class works with the BreakpointTarget class.
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
| Member name | Description | |
|---|---|---|
| Always | Execution is always suspended when the breakpoint is hit. | |
| Equal | Execution is suspended when the number of times the breakpoint has occurred is equal to the hit count. | |
| Expression | Execution is suspended when the expression changes. | |
| GreaterOrEqual | Execution is suspended when the number of times the breakpoint has occurred is equal to or greater than the hit count. | |
| Multiple | Execution is suspended when a multiple of the hit count occurs. |
To add flexibility and power to a breakpoint, you can modify the behavior of a breakpoint by configuring the breakpoint hit count, which specifies the number of times a breakpoint occurs before the run-time engine is suspended, and the hit count type, which contains an expression that specifies when the breakpoint is hit. This value is used in the HitTest property.
The following code example modifies the default value of a BreakpointTarget using this enumeration.
Sample Output:
Description Break when the container receives the OnPreExecute event
Enabled? False
HitTest Always
ID -2147483647
--------------------------------------------
Description Break when the container receives the OnPreExecute event
Enabled? False
HitTest Equal
ID -2147483647