I wanted to run my SSIS package when ever a specific file is existed on the FTP server. Can I use windows File watcher to implement this or will it be used only to watch Local and Mapped folders on the computer?

The file watcher is for local folders only. Maybe you could do something with a Script Task that checks if something has changed...Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

WMI event watcher can perform the required. Check this for details : http://msdn.microsoft.com/en-us/library/ms141130.aspxHappy to help! Thanks. Regards and good Wishes, Deepak. In a revamp of my Blog!

Thanks for the reply. How can I do this with Script Task... Randomly 3 different specific files may be upload into my FTP site daily. I wanted to download those files into my local folder as soon as they uploaded into my FTP site.

WMI event watcher can perform the required. Check this for details : http://msdn.microsoft.com/en-us/library/ms141130.aspx Happy to help! Thanks. Regards and good Wishes, Deepak. In a revamp of my Blog! Not seeing examples for remote WMI events...Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

Thanks for the reply. How can I do this with Script Task... Randomly 3 different specific files may be upload into my FTP site daily. I wanted to download those files into my local folder as soon as they uploaded into my FTP site. I'm not a .Net expert.... you could do something with GetListing method to get a list of files in an ftp folder and if you run that script within a loop (SSIS For Loop or a .Net loop within the Script Task) you can compare the values between the runs. See this step 4 in this arcticle to see an example of a Script Task with the GetListing method. Downside is that it's not really an event watching thing... it's just doing a ftp call every x minutes. And here is a similar thread:http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/d22910d9-4ba9-4ea1-9a62-654798a287d1 and an other one: http://stackoverflow.com/questions/2226994/ftp-file-watcher-like-systemfilewatcher-in-net Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com