Many thanks...solved this error I got today based on your idea of checking data types! Fixed based on this:

"consistent use a data conversion transformation to return to the original data type"

Error was:

[OLE DB Destination [55]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred.

Error code: 0x80040E21.

[OLE DB Destination [55]] Error: Cannot create an OLE DB accessor. Verify that the column metadata is valid.

[DTS.Pipeline] Error: component "OLE DB Destination" (55) failed the pre-execute phase and returned error code 0xC0202025.