Step-thru Debugging of Script Transformation (June CTP)

Has anyone successfully debugged a Script transformation in a Data Flow by setting breakpoints and stepping through the logic of the script? I can't seem to get the breakpoints to stop execution.

Any assistance would be appreciated.

[236 byte] By [RaulVillaronga] at [2008-2-15]
# 1
Here is the current BOL content on this subject, from the topic "Coding the Script Component:"

Debugging the Script Component

The Script component does not support the use of breakpoints. As a result, you cannot step through your code and examine values as the package runs. You can monitor the execution of the Script component by using the following methods:

  • Interrupt execution and display a modal message by using the MessageBox.Show method in the System.Windows.Forms namespace.

  • Raise events for informational messages, warnings, and errors. The FireInformation, FireWarning, and FireError methods display the event description in the Visual Studio Output window; however, the FireProgress method, as well as the Console.Write and Console.WriteLine methods, do not display any information in the Output window.

  • Log events or user-defined messages to enabled logging providers.
DouglasL at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Integration Services...

SQL Server

Site Classified