I have multiple files in the Blob storage and the file data has to be copied into DB Table the table name as a file
Blob storage :
Azure SQL Table name :
I am using the pipeline :
And i am getting error in copy activity :
Please advise how to remove the .csv extension.
Thanks in advance