topic Re: from mssql to mysql in Talend Studio

from mssql to mysql

modara — Fri, 15 Nov 2024 22:33:04 GMT

Hi i have atached a doc file please with screen shot. pleases help

Re: from mssql to mysql

Anonymous — Thu, 15 Sep 2022 13:26:42 GMT

Can you show us a screenshot of your job please?

Re: from mssql to mysql

modara — Thu, 15 Sep 2022 13:47:54 GMT

I have no issue with other decimal data type column except SQTY which is sale Quantity column. and this column has same data type like others. I have tried to delete the table and re-create and many other ways but no luck. so what data type should i use. my digit is 10 and prefix or fraction is 6

Re: from mssql to mysql

Anonymous — Thu, 15 Sep 2022 13:59:14 GMT

Can you show me the source SQL statement (that is used in the component) and show me the SQL schema for your source DB?

Re: from mssql to mysql

modara — Thu, 15 Sep 2022 14:11:43 GMT

is it possible you can use anydesk to my computer and had a look into the issue

Re: from mssql to mysql

modara — Thu, 15 Sep 2022 14:21:13 GMT

Re: from mssql to mysql

Anonymous — Thu, 15 Sep 2022 16:26:56 GMT

Sorry, I meant can you copy and paste the SQL you are using here and show me the schema of your DB table, not what you are using in Talend? Also, I have just seen that you have two yellow triangles next to your components. Can you let me know what they say when you hover over them?

Re: from mssql to mysql

modara — Thu, 15 Sep 2022 18:49:43 GMT

hi rhall,

thanks for your support. appropriate it. With your guidance when i try to take

"SQL statement (that is used in the component) and show me the SQL schema for your source DB?"

I have seen my data type was not update. database admin actually change data type but didnt notified. so i retrieve table and the issue resolved.

I tried many ways but never though this it could happen

thank you so much.

Re: from mssql to mysql

Anonymous — Thu, 15 Sep 2022 21:10:48 GMT

Not a problem. I thought it was a bit odd that only one column was in error.