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