Debug a Package by Setting Breakpoints on a Task or a Container

This procedure describes how to set breakpoints in a package, a task, a For Loop container, a Foreach Loop container, or a Sequence container.

In SQL Server Data Tools (SSDT), open the Integration Services project that contains the package you want.
Double-click the package in which you want to set breakpoints.
In SSIS Designer, do the following:
- To set breakpoints in the package object, click the Control Flow tab, place the cursor anywhere on the background of the design surface, right-click, and then click Edit Breakpoints.
- To set breakpoints in a package control flow, click the Control Flow tab, right-click a task, a For Loop container, a Foreach Loop container, or a Sequence container, and then click Edit Breakpoints.
- To set breakpoints in an event handler, click the Event Handler tab, right-click a task, a For Loop container, a Foreach Loop container, or a Sequence container, and then click Edit Breakpoints.
In the Set Breakpoints <container name> dialog box, select the breakpoints to enable.
Optionally, modify the hit count type and the hit count number for each breakpoint.
To save the package, click Save Selected Items on the File menu.

Zobacz także