How to: Set a Breakpoint in Script in a Script Task

  • Article

This procedure describes how to set breakpoints in the scripts that are used in the Script task.

After you set breakpoints in the script for the Script task, the Set Breakpoints - <object name> dialog box lists the breakpoints with the built-in breakpoints available in the Script task.

Note

The Script task supports the use of breakpoints during debugging, but the Script component does not have support for breakpoints. For suggestions on debugging the Script component, see Coding and Debugging the Script Component.

To set a breakpoint in script

  1. In Business Intelligence Development Studio, open the Integration Services project that contains the package you want.

  2. Double-click the package that contains the script in which you want to set breakpoints.

  3. To open the Script task, click the Control Flow tab, and then double-click the Script task.

  4. Click Script and then click Design Script.

  5. In Microsoft Visual Studio for Applications, locate the line of script on which you want to set a breakpoint, right-click it, point to Breakpoint, and then click Insert Breakpoint. The breakpoint icon appears on the line of code.

  6. On the File menu, click Close and Return.

  7. Click OK.

  8. To save the package, click Save Selected Items on the File menu.

See Also

Other Resources

Debugging How-to Topics (SSIS)

Help and Information

Getting SQL Server 2005 Assistance