topic Error converting data type nvarchar to numeric in Talend Studio

Error converting data type nvarchar to numeric

Anonymous — Sat, 16 Nov 2024 03:04:00 GMT

I am getting error as "Error converting data type nvarchar to numeric" when I am trying to extract data from a CSV file using dynamic schema and load it to target table in db.I have already checked with the datatype in target table and source table, it's the same.

My job is running correctly for all steps and I am getting correct output in a CSV file but getting the above error while inserting into target table.

Re: Error converting data type nvarchar to numeric

manodwhb — Fri, 06 Mar 2020 08:49:36 GMT

@shrath , As part of your data may be it have some string characters ,because of which when you are loading into table it is giving this error.

Re: Error converting data type nvarchar to numeric

Anonymous — Fri, 06 Mar 2020 09:23:26 GMT

@manodwhb , My data has all the numeric values but I am getting the same error

Re: Error converting data type nvarchar to numeric

manodwhb — Fri, 06 Mar 2020 09:26:33 GMT

@shrath , can you share your component screenshots of schema of csv and database and let me know which column is that?