Avatar

Correct answer by
Level 4

Hi @PoonamBhardwaj,

How are you processing the files when they are fetched by the File Transfer activity?

For processing files one by one, normally you would use a File Collector activity after the File Transfer activity, and check the box which says "Stop as soon as a file has been processed". This way the file that has the oldest timestamp of modification will be processed first, and so on, in order.

Add the Data Loading Activity after that to process the file contents.

Run the File Collector and Data Loading activities in a loop, and bring the workflow to a stop when all files have been processed.

 

I hope that helps.

 

Thanks,

Ishan

View solution in original post