I have text file that has the custom delimiter ^ on the source text file like below
I want to insert this data from the .txt file in to the Azure SQL Server Database, how can this be handled in Azure Data Factory. On the Source Dataset I have set the Connection parameters like below
But when I try to preview the dataset it doesnot show anything
How to handle the text files with custom delimiters in ADF.
CodePudding user response：
looks like file is not pointed to in your dataset
Reference video :