Execute files on time difference

I would like to extract specific files from the server based on the desired time difference or duration. If specific files has not been modified on determined time then a notification e-mail shall be sent to the assigned personnel.

Daniel

Our option is to neither write a script to check the modification dates nor we can use transformations - which is an easier pick.

To use transformation. We need to at least create two transformations, one is to check the file for the time difference and the second is to load the data.

To check the modification. We have to set the DataReader source to File System and enter the filename into the mask field.



The screenshot below shows the validation in checking the validation date - let's say less than 2 hours.

The package should somehow look like this.


.