Debugging a Script Component in SSIS

As we have discussed how to debug a script task in SSIS, some readers asked “how to debug a script component in SSIS”. Before I wrap up my own examples, I highly suggest reading these two excellent articles:

1. Script Component Debugging in SSIS 2012

2. Breakpoint does not work within SSIS Script Component

You will learn three main methods to monitor a script component:

1. Display a modal message by using the MessageBox.Show.
2. Raise events for informational messages, warnings, and errors.
3. Log events or user-defined messages.

Also you will get an idea about the limitation of situations that you can debug a script component for current versions of SSIS.