In the BIDS, navigate to the control flow interface. Right click on the object where you want to set the breakpoint and select the 'Edit Breakpoints...' option. This will display the screen shot listed next section.
What are the conditions that I can set for a breakpoint in SSIS?
Breakpoints have 10 unique conditions when they can be invoked. The breakpoints can also be used in combination. One typical example is using both the OnPreExecute and OnPostExecute events to determine the status of the variables as the process begins and ends.
What other breakpoint parameters can be configured?
For each of the breakpoints, the Hit Count Type and Hit Count can be configured.
The Hit Count Type values are:
* Always
* Hit count greater than or equal to
* Hit count multiple
* Hit count equals
The Hit Count value is an integer greater than 1.
The image below shows an example of these options, but is only an example not a probable configuration.
Next Steps
