https://communities.sas.com/t5/Administration-and-Deployment/Data-Target-Insert-node-error/m-p/804794#M24113 <P>Conversion failure typically means that a value cannot be converted in a number on the receiving side. Possibly the variable source is character.</P> <P>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.</P> <P>You would have to examine the specific record(s), variables and the target table to determine exactly what is incompatible.</P> Tue, 29 Mar 2022 15:30:12 GMT ballardw 2022-03-29T15:30:12Z https://communities.sas.com/t5/Administration-and-Deployment/Data-Target-Insert-node-error/m-p/804787#M24112 <P>Hi everyone.</P><P>&nbsp;</P><P>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."</P><P>&nbsp;</P><P>Do you have any idea what can cause this error?</P><P>&nbsp;</P><P>Thank you in advance!</P> Tue, 29 Mar 2022 14:56:03 GMT https://communities.sas.com/t5/Administration-and-Deployment/Data-Target-Insert-node-error/m-p/804787#M24112 Chrisas 2022-03-29T14:56:03Z https://communities.sas.com/t5/Administration-and-Deployment/Data-Target-Insert-node-error/m-p/804794#M24113 <P>Conversion failure typically means that a value cannot be converted in a number on the receiving side. Possibly the variable source is character.</P> <P>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.</P> <P>You would have to examine the specific record(s), variables and the target table to determine exactly what is incompatible.</P> Tue, 29 Mar 2022 15:30:12 GMT https://communities.sas.com/t5/Administration-and-Deployment/Data-Target-Insert-node-error/m-p/804794#M24113 ballardw 2022-03-29T15:30:12Z