Can SQL Server 2005 trap a change to an FTP folder?

• malcolmwatt

  SSC Veteran

  Points: 239

  More actions

  January 8, 2009 at 2:35 pm

  #126349

  Please:

  (1) I'd like to execute an SSIS package against a file in an FTP folder on Windows Server 2003.

  (2) I'd like to do it . . . whenever there's a change to the FTP folder (for example: arrival of a new file).

  (3) Is there any way at all for SQL Server 2005 to trap that event automatically?

  (4) Or do I need to run a periodic job . . . to test and see?

  Thanks.

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  January 8, 2009 at 10:52 pm

  #923919

  malcolmwatt (1/8/2009)

  ---

  Please:

  (1) I'd like to execute an SSIS package against a file in an FTP folder on Windows Server 2003.

  (2) I'd like to do it . . . whenever there's a change to the FTP folder (for example: arrival of a new file).

  (3) Is there any way at all for SQL Server 2005 to trap that event automatically?

  (4) Or do I need to run a periodic job . . . to test and see?

  Thanks.

  I could not think of any better option other than 4.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/