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

