There is a client requirement to load multiple structurally similar files (the system generates new files) from the source data.
Is it possible for the ADO "source Data " step to read multiple files from a folder path (instead of a single CSV file), append all these files, and then pass the combined data to the ADO an then to the transformation view?
If yes, when there are already 4 files in the folder and the system creates a new one, will the existing data source connection be sufficient to read the new file in that folder as well?
