Metadata driven copy task: "Invalid control table schema: CopyEnabled is required"

Question

I have already a metadata driven copy task in use, however would like to extend it with another database source table. I entered the menu, provided the Azure SQL database as location of the mainControlTable and specified the table. However I get the error message "Invalid control table schema: CopyEnabled is required".

The existing copy task is retrieving the delta (and not a full copy) of the source database (Oracle), but I hope this is not a problem.
Does anyone have a clue what this could mean?

Answer 1

Hello @John Connor
Thanks for the ask and using the Microsoft Q&A platform .

ADF internally creates a medata date table with the below structure and the it uses that in the pipeline .I am guessing that the table which you have is missing the column .

CREATE TABLE [sometest].MainControlTable_nqo

I think there are other configuration also , please review the same on the "Review and Finish" option ( screenshot attached )

Please do let me know how it goes .
Thanks
Himanshu
Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members