Column 'Name' does not belong to table Schema Table
Posted: Mon 08 Aug 2016 20:49
Devart Salesforce Lookup and Destination are configured to update a subset of fields in the Opportunity table. The package works without issues.
A column is added to the Opportunity table. The package fails with the following error:
The column "Name" is a standard field. The component does not reference it.
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?
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?