Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
2,442 questions
"Unable to start program 'DTS' ssis error" upon executing SSIS package on my local machine
Maria Angelica Intes
1
Reputation point
Installed:
Visual Studio Professional 2019 version 16.11.15
Microsoft SQL Server Integration Services Projects version 4.0
Machine: Dell Latitude 3410, Windows 11
Description:
Upon clicking the Start button on Visual Studio 2019, the SSIS package is unable to run due to the debugger-related error. See details below:
Failed to start project (Microsoft Visual Studio)
===================================
Error starting debugging. (Microsoft.DataTransformationServices.VsIntegration)
------------------------------
Program Location:
at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.LaunchVsDebugger(Boolean isRemoteTest, 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'.
Operation not supported. Unknown error: 0x80040038. (Microsoft Visual Studio Debugger)
------------------------------
Program Location:
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.LaunchVsDebugger(Boolean isRemoteTest, IVsDebugger iVsDebugger, DataTransformationsProjectConfigurationOptions options)
Visual Studio
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,857 questions
{count} votes
-
Yitzhak Khabinsky 20,016 Reputation points
2022-06-08T15:06:59.557+00:00 Please edit your original question, and add the following:
- Version of VS2019.
- Version of Microsoft SQL Server Integration Services Projects extension for VS2019.
-
Maria Angelica Intes 1 Reputation point
2022-06-09T01:29:12.63+00:00 Updated
-
Tianyu Sun-MSFT 13,091 Reputation points Microsoft Employee
2022-06-09T10:03:43.743+00:00 Hi @Maria Angelica Intes , could you first try to repair VS from VS Installer? If this doesn’t work, please try to uninstall and reinstall this SSIS extension in VS 2019:
Microsoft SQL Server Integration Services Projects. -
Maria Angelica Intes 1 Reputation point
2022-06-10T01:43:48.543+00:00 Hi @Tianyu Sun-MSFT - Did that multiples times already but no luck :(
-
Tianyu Sun-MSFT 13,091 Reputation points Microsoft Employee
2022-06-13T09:49:53.02+00:00 Hi @Maria Angelica Intes , Sorry for delay in reply. I test in two versions of VS 2019 on two machines but I still can’t reproduce this issue.
Are all the packages failed to start debugging on your side? Does this issue appear in a newly created IS project? Looks like some files about debugging were corrupted, Could you try to reset VS settings/repair system files? If it is possible, and if above methods don’t work, I think you may try to uninstall IS extension, uninstall VS 2019 and uninstall VS Installer, and then reinstall them again, as the last resort. BTW, I suggest you also open a ticket on our Developer Community, and attach related system log information, in case the issue is caused by Windows 11, or maybe it’s a potential issue.
Regards,
Tianyu
Sign in to comment