Is there a way to get the file system item source to import the file name into the dataflow and map it to a delimited destination?
There’s a filename node in File system Item source. You can use this to write FileName of all source files in the directory in the delimited destination in the dataflow.
First create an input variable ‘filename’ in the dataflow and map this to the delimited destination field. Then in workflow, open this dataflow and map ‘FileName’ from File System Item Source onto the ‘filename’ field in RunDataflow object. This will bring names of all files in the directory and write it in the delimited destination.
