How to map a Column to Identity Column from a Source to a Table in Azure SQL using Azure Data Factory

I am using Azure Data Factory and Azure SQL.

I am using using Copy data Activity from Move and transform.

My source is a csv file with same column names as the column names in my destination table in Azure SQL.

Now, I have an auto-increment primary key My_Emp_ID in my table(sink).

ADF is asking to match this column with source, but I do not have any such thing in my source(csv).

Here is the screen shot:

enter image description here

Please let me know how can I successfully load the data and the auto-increment key automatically increment value in Azure SQL.

Read more here: Source link