How to avoid duplicate records in SQL via ADf Archives | Cloudfronts - Microsoft Dynamics 365 | Power BI | Azure

Tag Archives: How to avoid duplicate records in SQL via ADf

How to Upsert Records in SQL(Sink) through ADF?

Introduction We are performing Integration of Accounts from CRM to SQL using ADF Copy activity pipeline. We want to upsert the accounts instead of inserting duplicate records again. Step 1: Auto create the Table named “accounts” in SQL Server during the first Integration run by selecting the Auto create table option.   Step 2: Create … Continue reading How to Upsert Records in SQL(Sink) through ADF?