Conversion failed when converting the nvarchar value to data type int.

talendstar — Sat, 16 Nov 2024 05:57:35 GMT

I have simple data flow that is loading a csv file into a SQL Server table.

However I am getting following error message:

Conversion failed when converting the nvarchar value '3W' to data type int.

I have narrowed down the column (UnitType - please attached image) where this value is stored. Both in source and destination this column is defined as string.

I am using a tmap in between the source tfileinputdelimited and tmssqloutput.

Please see attached images.

Any thoughts on what is going on here?

Thanks

Re: Conversion failed when converting the nvarchar value to data type int.

talendstar — Tue, 30 Apr 2019 18:44:04 GMT

nevermind - a developer had changed the underlying data def. got it to work once the table column data type was fixed.

thanks

topic Re: Conversion failed when converting the nvarchar value to data type int. in Talend Studio

Conversion failed when converting the nvarchar value to data type int.

Re: Conversion failed when converting the nvarchar value to data type int.