One Star

conversion from data type nvarchar to money

Hello:
I need to insert values into a database but when I try to do it and the JOB start running, Talend show this error:
Disallowed implicit conversion from data type nvarchar to data type money. Use the CONVERT function to run this query.
I would appreciate your help
7 REPLIES
Community Manager

Re: conversion from data type nvarchar to money

Hi
What does the data of this column looks like? Are there some null or empty value?
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: conversion from data type nvarchar to money

This is the Tmap.
One Star

Re: conversion from data type nvarchar to money

There are several null records but they?re validated in TMAP (please watch the image that I loaded with the TMAP?s information ).
I don?t know how to apply the function CONVERT FUNCTION TO RUN THIS QUERY.
Community Manager

Re: conversion from data type nvarchar to money

Hi
What's the data of this column looks like? Decimal value such as "23.63"? Are there any string value? Please show us an example of input data.
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: conversion from data type nvarchar to money

this are some values
36.00
362.76
89.26
36.00
35.72
36.00
470.40
One Star

Re: conversion from data type nvarchar to money

Subtotal Float
Iva = String
tota Float
suma_ivagastos String

All the data i have to convert to type Object Money
Seven Stars

Re: conversion from data type nvarchar to money

Why are all your output schema columns defined as Objects? Set them to the appropriate type equivalent to your database schema e.g. Float and you should not have a problem.