Reading Unstructured Text from the entire file in Azure Data Factory

Question

I have a file which is present as a unstructured txt in ADLS. I want to read the entire file content as text and pass it to a Stored Procedure in Azure data factory. Can this be done through Azure data factory? Below is an example of the file:

Number: 101095
This is a sample 1

ABC

XYZ

END
Number: 101096
This is a sample 2

ABC2

XYZ2

hhhh2

END
Number: 101096
This is a sample 3

ABC3

XYZ3

MMMM3

END

Answer 1

I want to read the entire file content as text and pass it to a Stored Procedure in Azure data factory.

To read entire content from .txt file you need to use lookup activity.

Add the ADLS dataset with .txt file and column and row delimiter character which is not present in your data example " ` ".

data preview of file:

Then you can access it using @activity('Lookup1').output.value[0].Prop_0