Oracle OLE DB Error 0x80040E07 in SSIS
Posted by Russell Wright on August 17, 2012
If you find yourself dealing with running an OLE DB query against an Oracle database in SSIS and you get an error similar to this, make sure you are comparing dates using the Oracle TO_DATE function.
e.g. DOC_DATE >= TO_DATE( ’01-01-2012′, ‘MM-DD-YYYY’)
TO_DATE(TO_CHAR(SYSDATE – 7,’MM-DD-YYYY’),’MM-DD-YYYY’)
Source: Import Level tables Level1 Source 
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E07.
An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80040E07 Description: "ORA-01861: literal does not match format string".
ORA-01861: Literal does not match format string
Microsoft OLE DB Provider for Oracle 0x80040E07