This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 53%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVD%3C/text%3E%3C/svg%3E)
Just starting to explore Azure Synapse as a replacement/upgrade for our on-premise SQL Server/SSIS/SSAS based solution.
Majority of our feeds follow a truncate and load approach. Was hoping in Synapse (ADF) it would be something as simple as enabling a checkbox to truncate and load data into a table but I've been unable to find even a round about way to achieve that.
What's the best practice to do a truncate and load in Synapse/ADF?
Have a look at the Sink Settings in Data Flows, similar to SSIS data flows. You'll see options there for insert, update, delete, truncate, etc.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 94%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
I have the same settings but when I run this on an allready populated table it only truncates the data, but it does not insert anything..
Hello @daJahrenHerud-4996,
Since this thread is too old, I would recommend creating a new thread on the same forum with as much details about your issue as possible. That would make sure that your issue has better visibility in the community.