Debug a Script by Setting Breakpoints in a Script Task and Script Component
Applies To: SQL Server 2016 Preview
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.
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.