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

[talendstar]

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

[talendstar · Accepted solution]

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

thanks