Script Component Debugging and Indicators

Posted on April 13, 2012. Filed under: Debugging, SSIS | Tags: , , , |

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

image

But as you can also see there are no indicators anywhere to tell me a breakpoint has been set

image

 

A fuller example of debugging along with the restrictions are shown here

Liked it here?
Why not try sites on the blogroll...

Follow

Get every new post delivered to your Inbox.

Join 201 other followers