I am getting the following error when I try to link a date field from Source Qualifier to Target table in Informatica: ERROR 7/19/2019 9:05:26 AM node01_dev WRITER_1_*_1 WRT_8229 Database errors occurred: FnName: Execute -- [Informatica][ODBC SQL Server Wire Protocol driver]Timestamp parameters with zero scale must have a precision of 13, 16, or 19. Parameter number: 1, precision: 12. FnName: Execute -- [DataDirect][ODBC lib] Function sequence error
I have done the same thing (used datetime for a target) with another workflow and it ran successfully.
I have done a search on the internet with this error message but none of the solutions from my search resolved the problem.
The target table SA_Cases needs to have the data insert into it. Right now, the Monitor shows that all of the rows are rejected.
The source is a table in Oracle. The target is a table in Microsoft SQL Server
enter image description here enter image description here
Here is the mapping that worksenter image description here
The SA_Cases table, which is the Target table, has fields with spaces. I replaced the spaces with underscores and it works. The problem was the spaces in the field names.
