I am trying to copy images from azure blob storage to azure MSSQL.
For the dataset setup in azure blob storage, I think the most suitable one will be binary.
But I am getting an error 'Sink must be binary when source is binary dataset' when trying to push it to the MSSQL.
May I know
1. is it possible to copy image data using ADF else any other alternative for this
2. what is the suitable data type for image when we are defining the dataset for ADF