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

John Connor 316 Reputation points

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?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,884 questions
0 comments No comments
{count} votes

Accepted answer
  1. HimanshuSinha-msft 19,386 Reputation points Microsoft Employee

    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 .
    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

0 additional answers

Sort by: Most helpful