Hi Grover, Jyoti ,
Thankyou for using Microsoft Q&A platform and thanks for posting your query here.
Could you please share more details as what exactly you have tried in your solution. Are you using copy activity to copy the data from csv source file to the target datastore ? Are you using dataflow ? Where are you exactly getting the error?
I tried to create a sample csv file having first column as '@ID' and copied the file from one container to another using copy activity. It worked without any error.
In case you are trying to copy from csv(ADLS) to SQL table, you could try mapping the column to remove @ in the target like below:
However , if you are getting this error in dataflow, then kindly try removing auto mapping and use select transformation having replace function to replace @ with blank '' in the column name.
Related resources: https://stackoverflow.com/questions/68216473/data-factory-special-character-in-column-headers
https://stackoverflow.com/questions/70107912/how-to-escape-an-in-source-column-in-azure-data-factory
Hope it helps. Looking forward to your response. Thankyou