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?
Solved! Go to Solution.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables