Hi Pratim Das, Partha C , Thankyou for using Microsoft Q&A platform and thanks for posting your query here. As per my understanding you are trying to copy data from a file into Azure sql DB , however the challenge here is that the file is not having any extension.
Sink Must be Binary when Source is a Binary dataset.
You can't directly copy data from binary dataset to sql table, as When using Binary dataset in copy activity, you can only copy from Binary dataset to Binary dataset.
You mentioned that the source is in excel format, so try to select excel as the source dataset format, even though the file doesn't have any extension and try to use sink as sql table with auto-create table option so that it would create the table schema according to the source schema.
Hope it helps. Please let us know how it goes. If the answer helped you , kindly accept the answer by clicking on Accept answer
button. Thankyou