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
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
Hi @ewinkiser,
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.

Thanks so much @nasreen-akter , that is exactly what I was looking for. Sorry I didn't explain it very well and thanks again!
Mike Kiser
4 people are following this question.