tAzureSynapseOutput - insert if not exists property

[Burgo]

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.

[Anonymous]

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