I have SQL table with Attachment data in varbinary. I want to export it to binary file in ADLS. But getting error "Source must be binary when sink is binary dataset"

Question

Please suggest alternate solution if someone has done before.

Answer 1

Hi @Yogesh Nikam ,

Thank you for posting query in Microsoft Q&A Platform.

Above error will come, when you source dataset format is not binary but sink dataset format is binary.

In your case, your source data is SQL table, so might have used SQL dataset which is pointing to your table. Hence, you cannot use binary format as sink dataset type. Kindly use different format type depending on type of file(csv, parquet etc..,)

Below are file format types you can choose. except binary in this case.

Please note, in above if you want to generate file with extension .txt then inside dataset filename filed explicitly use file name .txt

Hope this helps. Please let me know if any further queries.

---------------

Please consider hitting Accept Answer button. Accepted answers help community as well.