A column is added to the Opportunity table. The package fails with the following error:
Code: Select all
The component has detected potential metadata corruption during validation.
Error at Data Flow Task [Devart Salesforce Destination [101]]: System.ArgumentException: Column 'Name' does not belong to table SchemaTable.
at System.Data.DataRow.GetDataColumn(String columnName)
at Devart.SSIS.DestinationComponent.b()
at Devart.SSIS.DestinationComponent.Validate()
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostValidate(IDTSManagedComponentWrapper100 wrapper)
If I refresh and remap the columns, the package runs again.
This is very worrisome. Is the design of the devart components so brittle that adding/deleting a table column not referenced by the component will cause the component to fail?