Post reply

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

  • 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.

  • 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/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply