I am having one SISI package which do FTP task. I need to execute the ftp task untill it received the file(15 min sleep interval). I have the logic to check whether file received or not i.e. Every run stores the file count 0 or 1 in a log table. If 1 then file received. How to call the package again and again untill it pulls the file succesfully.

You can re-run the package conditionally from the outside by using say a VBScript or PowerShell script that will check the table. In both cases it uses DTSExec. Another option is to use SQL Agent, it all depends on how you want or need to approach this. You can even execute it using a stored procedure, in your case it seems more appropriate, but may be a little more difficult to implement What area specifically you need the help for? Just to give you an idea, (I just read this post) how to launch from a stored proc: http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/execute-ssis-from-sqlArthur My Blog

I am having one SISI package which do FTP task. I need to execute the ftp task untill it received the file(15 min sleep interval). I have the logic to check whether file received or not i.e. Every run stores the file count 0 or 1 in a log table. If 1 then file received. How to call the package again and again untill it pulls the file succesfully. I would recommend you keep the package executing in memory, until you receive the file. You can do it in a loop with a script inside, which sets a variable controlling the loop. The script can also do the time sleep interval.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Hi, You can use the WMI task to check the existence of the file in the folder. The package could be executed once the file is placed in the source folder. Check this for more information - http://www.bidn.com/blogs/MikeDavis/ssis/157/ssis-wmi-event-watcher-check-file-exist-creation Alternatively, you can also use the FileWatcher task. You can download it from here - http://www.sqlis.com/sqlis/post/File-Watcher-Task.aspx Hope this helps. Cheers, Shalin Shalin Kapadia

Check this as well - http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/a205a4b5-e445-4df9-8a87-d761080e99b4/Shalin Kapadia