title: Delete data from destination tables before running copy data activity
body: <p>I am trying to create a pipeline that moves data between some Oracle databases. I have successfully created and tested the <a href="https://docs.microsoft.com/en-us/azure/data-factory/copy-activity-overview" rel="nofollow noreferrer">copy data</a> activities. My problem is I want to empty the destination tables before the "copy" runs and I can't see a way to do that (right now it appends data to the tables).</p>
  
  <p>At first I tried using the <a href="https://docs.microsoft.com/en-us/azure/data-factory/transform-data-using-stored-procedure" rel="nofollow noreferrer">Stored Procedure</a> activity, but that only supports SQL Server-related sources. None of the other activities offered by data factory work for this use case. Even a generic "execute SQL" activity could work for me, but nothing like that appears to be available.</p>
  
  <p>EDIT: I have posted an answer below, but it's not ideal. Please post an answer if you think you have a better solution!</p>