locked
'Unable to start debugging' Error trying to execue SSIS task after installing VS 17 RRS feed

  • Question

  • Errors below.

    Package runs fine when deployed. Repro'd with a new project and a single "Execute SQL" task. 

    Machine is Windows server 2012 R2 Datacenter and had VS 2012 and 2015 installed before, these were uninstalled before starting the VS17 install. The installation of SSDT failed the first time with the "unable to open registry" error documented here. I was able to complete the install by extracting the VSIX files and running them one by one in the payload folder.

    Per the error I ran the VS 17 repair and nothing changed. When I re-ran SSDT-ENU.Seup.exe it failed with:

    [2838:1AC0][2018-05-17T17:26:43]e000: MainViewModel.OnBundleAction: Bundle action failed: Recursion too deep; the stack overflowed (0x800703E9)

    SSIS TASK EXECUTION ERROR

    TITLE: 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 start program 'DTS' Operation not supported. Unknown error: 0x80070057. (Microsoft Visual Studio Debugger)


    Got a bug or feature request? Tell me about it at http://connect.microsoft.com. This posting is provided "AS IS" with no warranties, and confers no rights.

    Friday, May 18, 2018 12:46 AM

All replies

  • I have the same error in Visual Studio Enterprise 2017, version 15.7.1, when trying to debug an SSIS package. I installed SSDT for Visual Studio 2017 like described above (with the same registry update issue during the installation of SSDT for VS2017). I attempted to reinstall Visual Studio and SSDT, but that did not fix the problem. Please help.

    ===================================

    Failed to start project (Microsoft Visual Studio)

    ===================================

    Unable to start debugging.
    The debugger is not properly installed.
    Run setup to install or repair the debugger. (Microsoft.DataTransformationServices.VsIntegration)

    ------------------------------
    Program Location:

       at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.LaunchVsDebugger(IVsDebugger iVsDebugger, DataTransformationsProjectConfigurationOptions options)
       at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.ValidateAndRunDebugger(Int32 flags, IOutputWindow outputWindow, DataTransformationsProjectConfigurationOptions options)
       at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchDtsPackage(Int32 launchOptions, ProjectItem startupProjItem, DataTransformationsProjectConfigurationOptions options)
       at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchActivePackage(Int32 launchOptions)
       at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchDtsPackage(Int32 launchOptions, DataTransformationsProjectConfigurationOptions options)
       at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.Launch(Int32 launchOptions, DataTransformationsProjectConfigurationOptions options)

    ===================================

    Unable to start program 'DTS'.

    The debugger is not properly installed.  Cannot debug the requested type of code.  Run setup to install or repair the debugger. (Microsoft Visual Studio Debugger)

    ------------------------------
    Program Location:

       at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
       at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.LaunchVsDebugger(IVsDebugger iVsDebugger, DataTransformationsProjectConfigurationOptions options)

    Monday, May 21, 2018 7:14 PM
  • Ping? Microsoft? Anyone?

    Got a bug or feature request? Tell me about it at http://connect.microsoft.com. This posting is provided "AS IS" with no warranties, and confers no rights.

    Wednesday, May 30, 2018 5:51 PM