Search code examples
visual-studiossissql-server-data-tools

visual studio (SSDT) 2017 unable to start debugging


I recently installed a Visual Studio 2017 from SSDT package. I am testing a simple scenario a flat file source and an OLEDB destination with no C# or VB scripts involved, as well there are no debugging breakpoints in the code. When I try to execute package for SSIS project I get the error:

Microsoft Visual Studio Unable to start debugging. The debugger is not properly installed. Run setup to install or repair the debugger.

------------------------------ ADDITIONAL INFORMATION:

Unable to run program „DTS”.

DLL library of Visual Studio program named coloader80.dll is not properly installed. Repair the Visual Studio installation by using applet Add or Remove programs in Control panel.

If the problem persists you can manually register the coloader80.dll library >from command line, using instruction „regsvr32 "%CommonProgramFiles%\Microsoft Shared\VS7Debug\coloader80.dll"”. (Microsoft Visual Studio Debugger)

I tried to use the solution for a similar problem: https://developercommunity.visualstudio.com/content/problem/26630/the-debugger-is-not-properly-installed-cannot-debu.html

I removed the content of C:/Program files/Common Files/Microsoft shared/VS7Debug folder and reinstalled the VS, but it doesn't seem to work in my case.

Any other ideas would be appreciated.


Solution

  • I tried the sames solutions with no result.

    Today I solved with this solution:

    https://stackoverflow.com/questions/37299032/visual-studio-2015-the-hash-value-is-not-correct​

    > 1. Download: https://go.microsoft.com/fwlink/?LinkId=866452
    > 2. SSDT-Setup-ENU.exe /layout <folder name>
    > 3. Download: https://aka.ms/vs/15/release/vs_sql.exe
    > 4. vs_SQL.exe --layout <different folder name> (this takes a while, it's laying out ~4 GB)
    > 5. <different folder name>\vs_setup.exe --wait --nickname "SSDT" --passive
    > 6. <folder name>\SSDT-Setup-ENU.exe