My current workflow to address data quality issues is
- Open SSIS Project in Visual Studio
- Start SSIS Debugger
- Wait for Errors to Halt Processing
- Stop Debugger
- Address Errors (Update Derived Column Transformation)
- Start SSIS Debugger
- Hang after "Execute phase is beginning." - with some or no rows extracted
- Reboot
I'd like to avoid steps 7 and 8, but I'm not sure what to try next. I've tried killing VS and restarting the SSIS Service but rebooting is the only thing that seems to work.