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.
>Solution :
I encountered the same issue while copying data from a CSV file to an SQL table, which has an auto-increment primary key as shown below:
Following @Thom A’s suggestion, I deleted that column as shown below:
And tried to copy the data using the copy activity. The copy activity ran successfully, as shown below:
The data was successfully copied, as demonstrated below:
