title: SQL Server Data Tools 2017 for Visual Studio 2017 - Unable to start debugger error
body: <p>I'm having trouble with the debugger when trying to run a simple SSIS project involving importing a small sample CSV file into SQL Server.</p>
  
  <p>I have searched StackOverflow with "debugger error Microsoft.DataTransformationServices.VsIntegration" and looked at all the search results.</p>
  
  <p>It looks like someone else had the same issue with VS2015 about a year ago, but it never got resolved.</p>
  
  <p><a href="https://stackoverflow.com/questions/44447230/microsft-sql-server-data-tools-for-visual-studio-2015-giving-debugging-error">Microsft SQL Server Data Tools for Visual Studio 2015 giving debugging error</a></p>
  
  <p>I've tried looking at the Event Viewer and generated Visual Studio Logs but there's nothing there.</p>
  
  <p>I get 2 error messages when I try to execute the SSIS job.</p>
  
  <p>Error 1:</p>
  
  <pre><code>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)
  </code></pre>
  
  <p>Error 2:</p>
  
  <pre><code>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)
  </code></pre>
  
  <p>I had a lot of trouble getting SSDT installed and working with Visual Studio 2017 and had to resort to the solution here to get it working.</p>
  
  <p><a href="https://stackoverflow.com/questions/46421619/ssdt-installation-issue-failed-to-execute-exe-package">SSDT installation issue (Failed to execute EXE package.)</a></p>
  
  <p>Has anyone come across this issue and manage to overcome it?</p>
  
  <p>In the meantime, I will try reinstalling the packages in the payload folder and see if that will fix this issue.</p>