Failed to open the SSIS install path registry key. (Microsoft.SqlServer.ManagedDTS)

doug.moloney@uchealth.com 6 Reputation points
2023-05-10T11:43:46.34+00:00

Installed Visual Studio 2022 and have SQL Server Integration Services Projects 2022 installed and enabled.

When I open an existing Solution that contains a sql integration service project, dtsx package I am getting errors.

TITLE: Microsoft Visual Studio
------------------------------

Exception has been thrown by the target of an invocation.

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

Failed to open the SSIS install path registry key. (Microsoft.SqlServer.ManagedDTS)

------------------------------
BUTTONS:

OK
------------------------------
===================================

Exception has been thrown by the target of an invocation. (Microsoft Visual Studio)

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

   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Delegate.DynamicInvokeImpl(Object[] args)
   at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)

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

Failed to open the SSIS install path registry key. (Microsoft.SqlServer.ManagedDTS)

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

   at Microsoft.SqlServer.Dts.Runtime.ExtensionMapParser.ParseAll(PackageFormatVersionUpdate pkgFmtVerUpd, DTSTargetServerVersion targetServerVersion)
   at System.Lazy`1.CreateValue()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Lazy`1.get_Value()
   at Microsoft.SqlServer.Dts.Runtime.ManagedHelper.get_ExtensionMapping()
   at Microsoft.SqlServer.Dts.Runtime.ManagedHelper.GetExtensionMappingInfoByCreationName(String creationName, DTS_EXTENSION_MAPPING_INFO& mapInfo)
   at Microsoft.SqlServer.IntegrationServices.Designer.ToolboxPersist.GetIdentifierByCreationName(String creationName, DTSTargetServerVersion targetServerVersion)
   at Microsoft.SqlServer.IntegrationServices.Designer.ToolboxPersist.IsInEssential(ToolboxItem item)
   at Microsoft.SqlServer.IntegrationServices.Designer.ToolboxModel.AddToEssential(ToolboxItem item)
   at Microsoft.SqlServer.IntegrationServices.Designer.ToolboxModel.AddToolboxItem(ToolboxItem item)
   at Microsoft.SqlServer.IntegrationServices.Designer.ToolboxModel.AddDataFlowItems(PipelineComponentInfos compInfos)


TITLE: Microsoft Visual Studio
------------------------------

Exception has been thrown by the target of an invocation.

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

Failed to open the SSIS install path registry key. (Microsoft.SqlServer.ManagedDTS)

------------------------------
BUTTONS:

OK
------------------------------
===================================

Exception has been thrown by the target of an invocation. (Microsoft Visual Studio)

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

   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Delegate.DynamicInvokeImpl(Object[] args)
   at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)

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

Failed to open the SSIS install path registry key. (Microsoft.SqlServer.ManagedDTS)

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

   at Microsoft.SqlServer.Dts.Runtime.ExtensionMapParser.ParseAll(PackageFormatVersionUpdate pkgFmtVerUpd, DTSTargetServerVersion targetServerVersion)
   at System.Lazy`1.CreateValue()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Lazy`1.get_Value()
   at Microsoft.SqlServer.Dts.Runtime.ManagedHelper.get_ExtensionMapping()
   at Microsoft.SqlServer.Dts.Runtime.ManagedHelper.GetExtensionMappingInfoByCreationName(String creationName, DTS_EXTENSION_MAPPING_INFO& mapInfo)
   at Microsoft.SqlServer.IntegrationServices.Designer.ToolboxPersist.GetIdentifierByCreationName(String creationName, DTSTargetServerVersion targetServerVersion)
   at Microsoft.SqlServer.IntegrationServices.Designer.ToolboxPersist.IsInEssential(ToolboxItem item)
   at Microsoft.SqlServer.IntegrationServices.Designer.ToolboxModel.AddToEssential(ToolboxItem item)
   at Microsoft.SqlServer.IntegrationServices.Designer.ToolboxModel.AddToolboxItem(ToolboxItem item)
   at Microsoft.SqlServer.IntegrationServices.Designer.ToolboxModel.AddDataFlowItems(PipelineComponentInfos compInfos)


Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,413 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Jasper Veerman 15 Reputation points
    2023-06-28T07:41:27.35+00:00

    Hi,

    I experienced the same issues as this question mentioned. After re-reading the SQL Server Integration Services Projects 2022 extension version 1.0 Release notes I noticed: "SQL server 2016 is not supported as target server version."

    My project was targeting SQL Server 2016, so I changed the target to SQL Server 2019 and upgraded the packages, using VS 2019.

    After saving all changes I opened the SSIS solution using Visual Studio 2022 and all errors and warning had disappeared.

    I hope this will help you out.

    3 people found this answer helpful.
    0 comments No comments

  2. Anna Xiu-MSFT 30,821 Reputation points Microsoft Vendor
    2023-05-10T14:11:00.3366667+00:00

    Hi @doug,moloney, 

    Welcome to Microsoft Q&A! 

    Please update your VS2022 to the latest version with Visual Studio Installer.

    If it doesn’t work, you can try to reinstall the SQL Server Integration Services Projects 2022 extension. 

    Sincerely,

    Anna


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.