ISAM to NTFS date compare RRS feed

  • Question

  • I have been asked to devise a way to compare file creation dates between ISAM files and NTFS files.  1) I am not sure this can be done. 2) I have no idea how to do it. 3) This will become part of a SQL Server DTS package currently running.


    The purpose: We currently FTP ISAM files over into NTFs text files. These files are BCP'd into SQL Server files.

    Last week we found out that one of the files were several days old.  We kept FTPing the same file for several days.

    So, this idea was born. Check the dates on the files to make sure the ISAM files are newer than the files we FTP'd the day before.  ANY ideas?


    Thanks for any light you can shine on this problem.


    Tom Herrmann

    Tuesday, February 26, 2008 7:17 PM


  • Tom,

    Would you mind to engage in any of the Technet forums? Those kind of forums are closer related with the nature of your inquiry: IT infrastructure


    Thursday, March 27, 2008 9:25 PM