Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

Execute files on time difference 4 years 5 months ago #15019

  • Daniel
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 22
  • Thank you received: 0
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

Please Log in or Create an account to join the conversation.

Execute files on time difference 4 years 5 months ago #15020

Our option is to neither write a script to check the modification dates or 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 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.


.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 255 guests and no members online