SQL Server Performance

filesystemwatcher

Discussion in 'SQL Server 2005 Integration Services' started by arkiboys, Jun 19, 2008.

  1. arkiboys Member

    Hi,
    Is it possible to monitor the file changes inside a folder? i.e. changes to the files such as delete, update, creation?
    I can do this in .net but not sure if this is possible in ssis?
    Thanks
  2. moh_hassan20 New Member

    Monitoring folders is not built-in service of SSIS.
    To support that kind of services, SSIS provides a way to implement custom script code in your package to extend its abilities.
    SSIS provides three options to implement script code:
    The Script Task
    Script Component
    ActiveX Script Task.
    You can implement your program that you write using vb.net / C# for file change as a Script task in SSIS

Share This Page