Auto table creation in sink side is not applicable for your sink dataset

Thejas Prasad 1 Reputation point
2022-03-03T07:51:31.01+00:00

I am trying to copy data from my on premise postrge database to azure sql database but I am receiving the below error I have tried changing the destination file name dbo.filename but still the issue exists, I need a table to be auto created but after the selection of this option if I debug it throws the error ''Auto table creation in sink side is not applicable for your sink dataset DestinationDataset_y19. Please create a new one."

Could you please help me to get the issue resolved.

179563-image.png

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
724 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,702 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Nandan Hegde 29,901 Reputation points MVP
    2022-03-03T08:11:03.747+00:00

    Hey,
    Based on the error message your sink dataset doesnt support auto creation of table.

    Below are the list :
    https://azure.microsoft.com/en-in/updates/copy-activity-in-azure-data-factory-supports-creating-destination-table-automatically/

    Can you please confirm what is your dataset property?

    0 comments No comments