VS 2015 SSIS Script Tasks cannot be debugged

I just spent hours pulling my hair, trying to understand why my ssis Script Component did not break into the debugger by clicking on the breakpoint. I searched on the Internet and funded the 64-bit setup (Project → Properies → Debugging) to disconnect, but that didn't help me.

It turns out that if I use string interpolation ($ "{someVar}") in my code, then the debugger does not start. As soon as I replaced it with the old string.Format ("{0} ...", param1, ...) method, my breakpoints hit and I was able to execute the code.

The code works anyway, and it's just a debugger that is affected by the new syntax.

Hope this helps someone.

+9
source share
4

, , Roslyn Visual Studio. ( VS2015 SSIS Script)

, VS (2012) , . , 2012 ! - . VS2015 , .

+2

, ... , !

VS2015 SSIS Script. nameof(), , . : ,

+1

, # # 4.0 . Visual Studio 2015 (VSTA) SQL Server/SSIS 2016.

# 4.0, :

  • " " " ... ", Visual Studio (VSTA).
  • Project Properties.
  • Project Build, Advanced..
  • " " " " " # 4.0 ".
  • / , .
  • , VSTA,

# Script.

enter image description here

+1

, , / , , .

, Resharper, "Richard T. LaSalle" : SSIS ScriptTask

TL; DR, Resharper

0

All Articles