What is the Auto-Create Script to Delete Data From a DB Table in the COPY Activity of ADF?

Question

Hello @Nasreen Akter
What is the auto-create script that I need to use to delete data from a DB Table in the Source of a Copy Activity?

Thank you!
Mike Kiser

Answer 1

Hi @Mike Kiser ,

I am not exactly understand the ask. Would you please explain a little more if the following comments does not help. Thanks!

In the CopyActivity --> Sink, there is a "Pre-copy script" field where you can put your DELETE statement. This statement will execute prior inserting records in the table.