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)