Data Target (Insert) node error

[Chrisas]

Hi everyone.

I have a simple data job in DataFlux that needs to output the data into a table through the Data Target (Insert) node. However, I am getting an error "[4: DEST_ODBC:Data Target (Insert)] Data Access Component - Numeric conversion failed or overflowed."

Do you have any idea what can cause this error?

Thank you in advance!

[ballardw · Accepted solution]

Conversion failure typically means that a value cannot be converted in a number on the receiving side. Possibly the variable source is character.

Overflow typically means that a value is too large for the receiving variable. Such as a variable that has been defined to only hold values up to 9999 but the value in question is 99999999 or similar.

You would have to examine the specific record(s), variables and the target table to determine exactly what is incompatible.