What is a breakpoint in SSIS? How is it setup? How do you disable it?

Answer 1

Breakpoints allow the execution to be paused in order o review the status of the data, variables and the overall status of the SSIS package. Breakpoints in SSIS are set up through the BIDS wizard. In this wizard, one needs to navigate to the control flow interface. The object where the breakpoint needs to be applied needs to be selected. Following which, Edit breakpoints can be clicked.

Answer 2

A break point in SSIS is a stopping / exit point in the code. It is an opportunity for reviewing the status of the data, variables and all the status of SSIS package, given to the developer / DBA. Each break point has 10 unique conditions.

Break points are setup using BIDS. In BIDS, navigate through control flow. Right click on the object that is to set the break point, and click on ‘Edit break point…’.