The custom property "%1!s!" needs to be of type %2!s!.

Community Notes

The following example code failed with this error because the AccessMode property of the Excel or OLE-DB Destination requires an integer to represent the OpenRowset member fo the underlying enumeration.

 destinationInstance.SetComponentProperty("AccessMode", "OpenRowset");

The correct code is shown below.

 destinationInstance.SetComponentProperty("AccessMode", 0);

Add your experiences and workarounds here. If you have solved this issue, why not help the next person?

ComponentErrorCodes