Debug a Script by Setting Breakpoints in a Script Task and Script Component
This procedure describes how to set breakpoints in the scripts that are used in the Script task and Script component.
After you set breakpoints in the script, the Set Breakpoints - <object name> dialog box lists the breakpoints, along with the built-in breakpoints.
Under certain circumstances, breakpoints in the Script task and Script component are ignored. For more information, see the Debugging the Script Task section in Coding and Debugging the Script Task and the Debugging the Script Component section in Coding and Debugging the Script Component.
To set a breakpoint in script
In SQL Server Data Tools (SSDT), open the Integration Services project that contains the package you want.
Double-click the package that contains the script in which you want to set breakpoints.
To open the Script task, click the Control Flow tab, and then double-click the Script task.
To open the Script component, click the Data Flow tab, and then double-click the Script component.
Click Script and then click Edit Script.
In Microsoft Visual Studio Tools for Applications (VSTA), locate the line of script on which you want to set a breakpoint, right-click that line, point to Breakpoint, and then click Insert Breakpoint.
The breakpoint icon appears on the line of code.
On the File menu, click Exit.
To save the package, click Save Selected Items on the File menu.