1. I am trying to read a .tsv file using OLEDB. The source file is on Desktop. Connection string I am using is -
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Users\akjindal\Desktop\;Extended Properties="text;HDR=YES;FMT=TabDelimited";
Query String is -
"SELECT * FROM [ABC.tsv]"
The error I am getting is -
Internal : Could not execute code stage because exception thrown by code stage: Cannot update. Database or object is read-only.
2. When I changed ABC.tsv to ABC.txt (ABC.txt is also on desktop). Code is running fine without any error but Output collection is having empty rows. Data is not extracted.
Any help on this. Thanks in advance.
