+2I am loading a table from an Oracle source with the ODX. When I load the table without an incremental selection rule, the table loads fine. But when I add an incremental rule on a datetime column (change date column in the source table) I get the error:
ORA-01861: literal does not match format string
Does the ODX server pass the correct where clause to the Oracle DB for the incremental load? Or am I doing something wrong?
Any help greatly appreciated!
Best answer by Syed Yousuf
Which version of TimeXtender are you using?
Release Notes for TimeXtender 20.10.x
This contains a new option for the ADO and OLEDB data sources called "Date and time syntax'
Options are: Default, ANSI, and ODBC.
For Oracle, you will need to set it to ANSI to get the date-time formatting to work.
Which version of TimeXtender are you using?
Release Notes for TimeXtender 20.10.x
This contains a new option for the ADO and OLEDB data sources called "Date and time syntax'
Options are: Default, ANSI, and ODBC.
For Oracle, you will need to set it to ANSI to get the date-time formatting to work.
+2Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
