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.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema