Inserting to mssql - update if new?

Hi

I have created a small table with these columns:
/****** Script for SelectTopNRows command from SSMS ******/
SELECT [ProductName]
,[ProductCode]
,[ProductCountry]
,[ProductType]
,[SubCarrierID]
,[SubCarrierName]
,[ProductStatus]
,[StartDate]
,[EndDate]
,[MultiColli]
,[AvailableOnAPI]
,[ShopProduct]
,[Direction]
,[id]
FROM [MasterData].[Products]

ID is PK and has identity 1.

If ProductCode exist then its an update on that row.
If it does not, then its new and should be inserted.

How do i define my output to that?

This keeps adding as new $:\$

Database Connection

Accepted answers

nagakavyasri

There will be 'Key for Update' field when the option 'Update:Insert if new' selected to select the update column, try checking for this option

Screenshot 2023-06-07 120158.png

All comments

geraldo

@Hamder83
Did you look at the mapping if everything is correct in the Append Field Map option?

If there is no other PK in the BD

and the pk and identity 1 field should not work

If you don't pass the ID Null to the update it will insert and not update

nagakavyasri

There will be 'Key for Update' field when the option 'Update:Insert if new' selected to select the update column, try checking for this option

Screenshot 2023-06-07 120158.png

Hamder83

oh, I didnt have that option of using oledb. I changed it to odbc and it worked.

Thank you :-)

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703