This is the Error message
SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "OLE DB Destination.Inputs[OLE DB Destination Input]" failed because error code 0xC0209077 occurred
This is my oracle date source format
31-DEC-18
and this is my destination table
[COVERAGEEFFECTIVEDATE] [varchar](10) NULL