VS 2015 SSIS Script Tasks cannot be debugged

by

Indeed, limiting C# Script Tasks to language features of C# 4.0 brings the Debugger back to life. In my case, adding a single null-coalescing operator caused the debugger issue using Visual Studio 2015 (VSTA) on SQL Server/SSIS 2016.

To restrict the Script to C# 4.0 we can enforce a specific Language Level in the Build settings of the Task:

  • Open the Script Task in question, click the “Edit Script…” button to open Visual Studio (VSTA).
  • In the Solution Explorer right-click the Project node and select Properties
  • In the Project window, go the Build tab, scroll down and click the Advanced.. button.
  • In the Advanced Build Settings window change the Langauge Version from “default” to “C# 4.0“.
  • Clean/Rebuild the Script Task, fix compilation errors.
  • Finally, exit VSTA, rebuild the project

and then you should be able to debug the C# Script Task again.

enter image description here

More Related Contents:

  1. C# Find Duplicate Values in a Datatable
  2. Why covariance and contravariance do not support value type
  3. Why doesn’t C# infer my generic types?
  4. Why isn’t there generic variance for classes in C# 4.0?
  5. How does the C# compiler detect COM types?
  6. Stop visual studio debug putting slash in string containing double quotes
  7. How do I get the current line number?
  8. How to call a C# library from Native C++ (using C++\CLI and IJW)
  9. Better naming in Tuple classes than “Item1”, “Item2”
  10. Will the dynamic keyword in C#4 support extension methods?
  11. creating WCF ChannelFactory
  12. How to detect a process start & end using c# in windows?
  13. Visual Studio 2015 not syntax highlighting razor nor Intellisense
  14. method overloading vs optional parameter in C# 4.0 [duplicate]
  15. Could not load file or assembly “System.Net.Http, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a”
  16. How to access ssis package variables inside script component
  17. Project builds but can’t publish
  18. Impersonate user in Windows Service
  19. Datetime in C# add days
  20. Is Graphics.DrawImage too slow for bigger images?
  21. Does the System.Windows.Forms.Timer run on a different thread than the UI?
  22. Primary constructors no longer compile in VS2015
  23. Extracting Windows File Properties (Custom Properties) C#
  24. Better way to query a page of data and get total count in entity framework 4.1?
  25. Connecting to Oracle Database through C#?
  26. Reverse engineering SSIS package using C#
  27. Go To Definition: “Cannot navigate to the symbol under the caret.”
  28. C# ModInverse Function
  29. How to add and get Header values in WebApi
  30. C# Xml Serialization & Deserialization

Leave a Comment