Forum Discussion
SSIS Debug Spawns 2 DtsDebugHost.exe and Freezes
Operating System: Windows 10 Enterprise
Visual Studio: 2022 Enterprise (x64)
Target SQL Server: SQL Server 2019
On many packages, running the package in debug mode (x64, ??) locks up the UI (windows message "Visual Studio is Busy").
Task Manager shows 2 instances of DtsDebugHost star
C:\Program Files\Microsoft Visual Studio\2022\Enterprise\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\Binn each with different -regas {guid} command lines.
For packages where this doesn't happen only 1 is spawned.
Killing the DtsDebugHost.exe packages frees up the Visual Studio GUI but ends the debug session.
These packages do not use any 3rd party components.
1 Reply
I think I figured it out - not sure what is going on though.
I had a very simple error handler for the package - it just updates a table w/ some variables. When I delete the error handler debugging works great!
