Hi All, I need to move a few files from one location(ftp) to another. The tricky thing here is, there is no specific time at which the files will be created as the will be generated on demand. I can create a packge to do this but how often should I run my job? Any insight into this? Thanks in advance for your help.

you can use File system task to move file as you want. probably you know how to do it, it is simple to configure. and another part is that you can create a File Watcher solution with resort of WMI Event Watcher task. this is a sample : FOR INDIVIDUAL FILE : SELECT * FROM __InstanceCreationEvent WITHIN 60 WHERE TargetInstance ISA 'CIM_DataFile' AND TargetInstance.Name = 'c:\\ImportData\\test.txt' FOR WATCHING A FOLDER : SELECT * FROM __instancecreationevent WITHIN 60 WHERE TargetInstance ISA 'Cim_DirectoryContainsFile' AND TargetInstance.GroupComponent='Win32_Directory.Name="c:\\\\ImportData"' reference: http://www.sqlservercentral.com/Forums/Topic473313-148-1.aspxhttp://www.rad.pasfu.com

I Agree with Reza. The WMI Event Watcher Task will help you here. You start the package and it waits untill the new file(s) arive.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

Another way is schedule your package to run lets say every 15mins. Have the first task to chek if the file exists. If yes proceed else exit the run(use precedence constraint)My Blog | Ask Me

Thanks all for the feedback. All these files will be in folders. Is there a way to track which file was transfered and at what time etc? We want to track this information. Please advise.

Thanks all for the feedback. All these files will be in folders. Is there a way to track which file was transfered and at what time etc? We want to track this information. Please advise. you can implement it yourself. I mean that put an execute sql task and fetch the pick time of each file, the transfer time and any other thing you need to an sql server table. or write a .NET code in script task and write log as you need with your own logic.http://www.rad.pasfu.com

Thanks Reza, I am moving folders, is it possible to track transfer at the file level when am moving folders? I am not familiar with how to do this, can you please provide more details?

Thanks Reza, I am moving folders, is it possible to track transfer at the file level when am moving folders? I am not familiar with how to do this, can you please provide more details? This doesn't make sense to me. could you explain more what you trying to do?http://www.rad.pasfu.com