How to COLLATE in TMSSQLOUT

amtkmr1990 · ‎2020-07-21

Hi Team,

I am using TMSSQLoutput component to insert data to MS SQL server table.

I am using vm_id as update key.

vm_id are as below

vm01abX

vm01ABx

vm02dcV

vm02DCV

If you observer they have different cases but while writing to table it consider

vm01abX and vm01ABx same. And data is getting over written.

How can i solve this for MS SQL Server or TMSSQLOUTPUT component.

In TSQL we have COLLATE option, Do we have any option in talend

manodwhb · ‎2020-07-21

@AmitKumar patil , check the below link and while you creating the connection for the db in the metadata you can add in additional parameters.

amtkmr1990 · ‎2020-07-22

Thanks i had a look but did not understand i exactly i have to do.

Could you give some screenshots