Script Component Debugging and Indicators

Posted on April 13, 2012. Filed under: Debugging, SSIS | Tags: Debug, Script Component, SQL Server 2012, SSIS |

In SSIS prior to SQL Server 2012 we were allowed to set breakpoints in Script components but when the parent Data Flow task executed these breakpoints were ignored.

In SSIS for SQL Server 2012 we are allowed to set breakpoints in a script component and they will be honoured. This is a good thing because it stops me having to use something like the following code (although I still use this as well) along with DebugView

    public override void Input0_ProcessInputRow(Input0Buffer Row)
    {
        i += 1;

        Debugmsg = string.Format("DEBUG: New row has come through {0},  ({1})", i, Row.CurrencyName);

        msg = string.Format("OUTPUT {0},({1})", i, Row.CurrencyName);

        System.Diagnostics.Trace.WriteLine(Debugmsg);

    }

The problem is that after having set a breakpoint within the Script Component neither the component itself or the parent Data Flow task indicates this to the user.

I have opened a connect suggestion

As you can see debugging works