Export (0) Print
Expand All

Debugging Script


You write the scripts that the Script task and Script component use, in Microsoft Visual Studio Tools for Applications (VSTA).

You set and script breakpoints in VSTA. You can manage breakpoints in VSTA, but you can also manage the breakpoints using the Set Breakpoints dialog box that SSIS Designer provides. For more information, see Debugging Control Flow.

The Set Breakpoints dialog box includes the script breakpoints. These breakpoints appear at the bottom of the breakpoint list, and display the line number and the name of the function in which the breakpoint appears. You can delete a script breakpoint from the Set Breakpoints dialog box.

At run time, the breakpoints set on lines of code in script are integrated with the breakpoints set on the package or the tasks and containers in the package. The debugger can run from a breakpoint in the script to a breakpoint set on the package, task, or container, and vice versa. For example, a package might have breakpoints set on the break conditions that occur when the package receives the OnPreExecute and OnPostExecute events, and also have a Script task that has breakpoints on lines of its script. In this scenario, the package can suspend execution on the break condition associated with the OnPreExecute event, run to the breakpoints in the script, and finally run to the break condition associated with the OnPostExecute event.

For more information about debugging the Script task and Script component, see Coding and Debugging the Script Task and Coding and Debugging the Script Component.

To set a breakpoint in Visual Studio for Applications

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft