conversion from data type nvarchar to money

[Anonymous]

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

[Anonymous]

Hi
What does the data of this column looks like? Are there some null or empty value?

[Anonymous]

This is the Tmap.

[Anonymous]

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.

[Anonymous]

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.

[Anonymous]

this are some values
36.00
362.76
89.26
36.00
35.72
36.00
470.40

[Anonymous]

Subtotal Float
Iva = String
tota Float
suma_ivagastos String

All the data i have to convert to type Object Money

[alevy]

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.