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

Seven Stars

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

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.

 

talend1.PNGtalend2.PNG

 

 

 

Please see attached images.

 

Any thoughts on what is going on here? 

 

Thanks


Accepted Solutions
Seven Stars

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

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

 

thanks


All Replies
Seven Stars

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

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

 

thanks

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog