Copy Activity failure on simple .txt file move from on prem to ADLS Gen2

Question

Copy Activity Source and Sink , I am keep getting this error while moving .txt file from on prem to ADLS , below is the header and first tow rows
File with Just two rows and header also erroring out , first row is header and next two rows are sample, pipe delimited.

product_id|product_name|host_product_code|product_type_id|product_type_name|host_product_type_code
13|External Checking|ExtDda|4|External Deposit Accounts|DExt
14|External Savings|ExtSav|4|External Deposit Accounts|DExt

Failure happened on 'Sink' side. ErrorCode=DelimitedTextColumnNameNotAllowNull,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The name of column index 2 is empty. Make sure column name is properly specified in the header row.,Source=Microsoft.DataTransfer.Common,'

Answer 1

Looks like you want to copy the file from on prem to ADLS location i.e. simply copy pasting the file itself.

In this case, can you try creating binary type (instead of Delimited text) of dataset for Source & Sink and see if using these datasets works. If possible, please put some screenshots if its not working.

---

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav