Unable to debut SSIS Script Task with VS 2017 15.8.7 and SSDT for SQL 2016

234 Views Asked by At

I have an SSIS Project built in Visual Studio 2017 with Data Tools for SQL 2016, and I'm unable to debug any of the Script Tasks. I create break points which shows the red dot in the designer, but none of them ever hit. I'm not getting any errors or warning, or not sure where to check if I am getting any. I'm having to put Message Boxes in to walk through the code.

I've tested with Run64BitRuntime as True and False with the same results. I've also tried updating the "Optimize Code" option in the Build properties within the Script Task running checked and unchecked with the same results.

Any suggestions or thoughts? Thanks.

0

There are 0 best solutions below