DTS Package to check the modified date of remote text file

• cvvikram 71819

  SSC Enthusiast

  Points: 178

  More actions

  April 6, 2010 at 2:47 am

  #100720

  Hi Friends,

  Here is my situation, I need to update the existing DTS Package to check the modified date of dynamically generate text file. If the file modified date is different when compare to system date then i need to send the mail.

  Please let me know how to check the modified date of text file which is residing in another server within the network through DTS.

  Thanks

• K Cline

  Ten Centuries

  Points: 1391

  More actions

  April 6, 2010 at 11:55 am

  #1146687

  Use an ActiveX Script Task to check the DateLastModified of the file. If it meets your criteria use the Send Mail Task to send your message.

  Couple of links to get you started:

  Working with the FileSystemObject. Look for the File Date & Time section.

  Quick sample for some of the file object's date related properties.