I am working on a SSIS package that has some script components (in C#) inside data flow.
I used break points all the time with it and worked fine without any issue.
But yesterday suddenly it stopped working without throwing any errors or any. The script works fine without breaking or any error, giving me the expected results as well but does not stop on break points.
I didn't change any visual studio configurations or project configuration.
Google and tried all the solutions others provided.
Clear all cache and all debug objects, rebuild the solution again, restart the machine as well but none of those worked.
Does anyone have this kind of experience?
Environment: Windows 10 Pro, VS 2017
At last found the reason for the issue, the reason is that I used a conditional access operator inside the script. The compiler compiles the code properly and works fine but the debugger somehow doesn't understand that operator and crashes. Seems like SSDT use old C# version on debugging..