from mssql to mysql

[modara]

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

[Anonymous]

Can you show us a screenshot of your job please?

[modara]

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

[Anonymous]

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

[modara]

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

[modara]

[Anonymous · Accepted solution]

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?

[modara]

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.

[Anonymous]

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