After more research and trial-error, found that the SSIS package ignores the breakpoints in a Script Task when debugging on a 64-bit machine. To fix it –
- Go to the Solution Explorer
- Right click your SSIS project node > Properties
- In Configuration Properties > Debugging > Debug Options > Set
Run64BitRunTime
toFalse
.
After making this change, the breakpoints hit like magic.