Hello,
I currently have a pipeline that takes raw csv files from a blob and loads it into an azure sql DB. Since i have multiple different files, i am using a ForEach loop. The issue here is the datatype. The files being loaded from the blob into the DB are coming over a nvarchar(max) for all fields (even for date, int, float etc). Since its a ForEacch lop and a parameter for file (i.e childitems) , I cannot explicitly mention the mapping for each fields. Is there a way to overcome this or do i have to have a sperate flow for each file and mention the datatype for each fields.
Cheers.