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

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

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.

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

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…’.
Concepts and capabilities of Business Intelligence
Business Intelligence helps to manage data by applying different skills, technologies, security and quality risks....
Standard Business Intelligence tools in the market
Business intelligence tools are to report, analyze and present data. Few of the tools available in the market are:...
Explain the Dashboard in the business intelligence
A dashboard in business intellgence allows huge data and reports to be read in a single graphical interface.....
Post your comment