SSIS An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80004005 Description: "ORA-01840: input value not long enough for date format"

-1

I have the following SQL in Oracle:

 SELECT 
 CE.ENCNTR_ID                                              AS CernerEncounterID
,TO_DATE(S.ACTIVE_STATUS_DT_TM,'YYYY-MM-DD HH24:MI:SS')    AS NoteStartDateUTC
,S.AUTHOR_ID                                               AS CernerPersonID 
,S.STORY_COMPLETION_STATUS_CD
,CE.EVENT_CD                                               AS CernerNoteTypeCD
,TO_DATE(CE.VALID_FROM_DT_TM,'YYYY-MM-DD HH24:MI:SS')      AS VALID_FROM_DT_TM
,TO_DATE(CE.VALID_UNTIL_DT_TM,'YYYY-MM-DD HH24:MI:SS')     AS VALID_UNTIL_DT_TM 
,CE2.EVENT_CD                                              AS EVENT_CD  
,TO_DATE(CE2.VALID_FROM_DT_TM,'YYYY-MM-DD HH24:MI:SS')     AS AuthVerifiedValidFromDate 
,TO_DATE(CE2.EVENT_END_DT_TM,'YYYY-MM-DD HH24:MI:SS')      AS AuthVerifiedEventEndDate  
,TO_DATE(CE2.PERFORMED_DT_TM,'YYYY-MM-DD HH24:MI:SS')      AS AuthVerifiedPerformedDate
,TO_DATE(CE2.VERIFIED_DT_TM,'YYYY-MM-DD HH24:MI:SS')       AS AuthVerifiedDate
,TO_DATE(CE2.CLINSIG_UPDT_DT_TM,'YYYY-MM-DD HH24:MI:SS')   AS AuthVerifiedClinSigUpdateDate
,CE2.AUTHENTIC_FLAG       AS AuthVerifiedStatus
,CE.ENTRY_MODE_CD         AS CernerEntryModeDisplayCD
,S.TITLE
,STORY_TYPE_CD
,S.EVENT_ID
,S.ACTIVE_STATUS_CD
,TO_DATE(S.ACTIVE_STATUS_DT_TM,'YYYY-MM-DD HH24:MI:SS')    AS IncrementalDateTimeFlag

FROM 
Table01  S 
LEFT OUTER JOIN 
Table02  CE  
ON 
S.EVENT_ID = CE.EVENT_ID
LEFT OUTER JOIN
Table03  CE2  
ON 
S.EVENT_ID = CE2.EVENT_ID 
AND 
CE2.RESULT_STATUS_CD = 25
WHERE 
S.ACTIVE_STATUS_DT_TM >= TO_DATE('2019-06-20 00:00:00','YYYY-MM-DD HH24:MI:SS')

It runs without any issues in Oracle SQL Developer.

Executing in SSIS generates the following error:
An OLE DB record is available.  Source: "OraOLEDB"  Hresult: 0x80004005  Description: "ORA-01840: input value not long enough for date fo

rmat".

I have been seeking for info for a while, dead end so far. Could you please kindly advice?

oracle-11g
ssis
asked on Super User Jun 20, 2019 by user1052513 • edited Jun 20, 2019 by Sathyajith Bhat

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0