topic tAzureSynapseOutput - insert if not exists property in Talend Studio

tAzureSynapseOutput - insert if not exists property

Burgo — Fri, 15 Nov 2024 22:25:54 GMT

Hi all,

i've an Azure SQL table with the following primary key:

I insert records in it with the following part of code:

I've tracked in the file_7 of the log catcher_1 the following message:

It's not working the "insert if not exists" option or i'm messing with tDie or something else?

Thanks.

Re: tAzureSynapseOutput - insert if not exists property

Anonymous — Fri, 28 Oct 2022 04:31:53 GMT

Hello,

Have you tried to check that primary key does not exist in the database?

As you added PRIMARY KEY constraint in sql query, you're not doing an insert while there is an existed primary key, even if it has the same value as the row you're trying to update already.

Best reardsd

Sabrina