If you are unable to debug your script even after setting a break point, You need to check the below.
Is your script task in Control Flow or Data Flow ?
- Script can be written in Control Flow using "Script Task".
- Script can be written in DataFlow using a "Script Component".
We cannot debug script in DataFlow Task.
You can debug the script task in control flow by setting a breakpoint
, But the same is not possible for a Script Component. Instead you can
use MsgBox command to view that particular value.
You can also add DataViewers to view the output data.
If you need a particular reason for this.. Here are not accurate but supporting points..
1. Script Component can act as Source, Transform and Destination. So it's not secure to allow debugging for such sensitive Data.
2. Microsoft has not yet provided this feature . We can expect this in future releases. (Simple answer)