I am running into an issue when trying to parse the data from a config file in Data Factory. I am using a configuration file and the items are called in the copy activity. We have the option to parameterize the 'Column Delimiter' field from a data set, so I am using the value from the file (because in some cases is ';' and in others '\t'). When the delimiter is semicolon is working perfectly, but when it's \t , I get the following error :
Copy activity doesn't support multi-char or none column delimiter.
When I'm checking the value that goes into the field, I see that the value is not the one from the file (\t), but \\t.
Do you have any idea why this behavior or if there is an escape character for this one. I also tried with ASCII code (\0009) and I get the same error - it doesn't know to transform it. Thanks a lot!
Can you try passing a real tab copied from a text editor, like - ' '.
This has been seen to work. Had there been no parameterization in the delimiter, you could have done it through the GUI or even the code.