topic Re: conversion from data type nvarchar to money in Talend Studio

conversion from data type nvarchar to money

Anonymous — Tue, 25 Sep 2012 00:13:50 GMT

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

Re: conversion from data type nvarchar to money

Anonymous — Tue, 25 Sep 2012 01:45:57 GMT

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

Re: conversion from data type nvarchar to money

Anonymous — Tue, 25 Sep 2012 18:54:00 GMT

This is the Tmap.

Re: conversion from data type nvarchar to money

Anonymous — Thu, 27 Sep 2012 00:12:30 GMT

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.

Re: conversion from data type nvarchar to money

Anonymous — Thu, 27 Sep 2012 04:29:11 GMT

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.

Re: conversion from data type nvarchar to money

Anonymous — Thu, 27 Sep 2012 15:56:19 GMT

this are some values
36.00
362.76
89.26
36.00
35.72
36.00
470.40

Re: conversion from data type nvarchar to money

Anonymous — Thu, 27 Sep 2012 17:40:04 GMT

Subtotal Float
Iva = String
tota Float
suma_ivagastos String

All the data i have to convert to type Object Money

Re: conversion from data type nvarchar to money

alevy — Fri, 28 Sep 2012 03:39:13 GMT

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.