Sink must be binary when source is binary dataset

Question

I am new to the Azure Data Factory scene, trying out the copy data tutorial where I have an InputDataset with emp.txt with the following information:

firstname, lastname
John, Doe
Jane, Doe

And I want to have an OutputDataset in json format.

{
 "firstname" : John,
 "lastname" : Doe
}

How can I set it up correctly in the Pipeline? It keeps telling me sink must be binary when source is binary dataset.

Answer 1

Your requirement is very common,it could be done in ADF copy activity exactly.Please don't use binary format, use DelimitedText as source dataset and Json as sink dataset instead.

Please see my example:

DelimitedText dataset configuration:

And you could import Schema to check the key-value:

Json dataset configuration:

Select Array of Objects in Json Sink:

Test Output: