question

Chris 2 avatar image
Chris 2 asked

OraOLEDB ORA-01861 format error

Windows server 2016 and SQL 2016. Ran into "OraOLEDB" Hresult: 0x80040E14 Description: "ORA-01861: literal does not match format string" error when tried to query Oracle column defined as a DT_WSTR but has date value stored. It failed even tried TO_CHAR to enforce string returned. Is there a way to get around? Thanks.

ssis error
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.