question

ewinkiser avatar image
0 Votes"
ewinkiser asked ewinkiser commented

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

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

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

nasreen-akter avatar image
0 Votes"
nasreen-akter answered ewinkiser commented

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.

86250-img41.jpg



img41.jpg (54.2 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·