I have an SSIS custom component which was developed sometime ago, we are migrating our databases and SSIS packages to SQL Server 2022 and I am getting the following error when trying to use the custom component:
Error: System.MissingMethodException: Method not found: ‘Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSComponentMetaData100 Microsoft.SqlServer.Dts.Pipeline.PipelineComponent.get_ComponentMetaData()’.
at SSIS.Components.ErrorColumName.ColumnName.PreExecute()
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper)
I can see that the code uses
IDTSInput100 input = ComponentMetaData.InputCollection.GetObjectByID(inputID);
IDTSVirtualInput100 vInput = input.GetVirtualInput();
foreach (IDTSVirtualInputColumn100 vCol in vInput.VirtualInputColumnCollection)
but I am not clear on what has replaced this.
I appear to have IDTSComponentMetaData130
and similar, but I am concerned that this maybe because I have multiple versions of SQL on my development box, I cannot seem to find these references in SQL Server 2022 (only in 2019)
Microsoft.SqlServer.DTSPipelineWrap
Microsoft.SqlServer.DTSRuntimeWrap
Microsoft.SqlServer.PipelineHost
Looking for advice on SQL Server 2022 SSIS references and replacement calls to IDTSInput100
etc.
Thanks
Nikki is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.