SP triggered by local file update

• M McD

  Grasshopper

  Points: 13

  More actions

  September 10, 2007 at 11:51 pm

  #62074

  HI All,

  I have a ques I think will be very easy for most; I have an integration with another system that updates a file placed on the the local SQL server machine. I want to know what the best way to trigger the SP I have on that server, once the file is updated. I just don't know how to tell When that file is updated.

  Thanks,

  Mark

• philcart

  SSC-Forever

  Points: 47797

  More actions

  September 11, 2007 at 2:23 am

  #732689

  Probably best option would be a .Net File Watcher service.

  Within SQL you could setup a little VBScript to run in a SQL Agent job to check the Date Modified of the file.

  --------------------
  Colt 45 - the original point and click interface