InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 04:04:34 GMT20http://www.sqlservercentral.com/Forums/Topic1382227-391-1.aspxThis package is not run via the SQL Server agent job and I have other parts of the package processing while this piece is running. Thanks for the advice.Thu, 08 Nov 2012 08:55:57 GMTKasumisCathttp://www.sqlservercentral.com/Forums/Topic1382227-391-1.aspxIs the process executed by means of a SQL Agent job?if so, have you considered letting the SSIS fail, but set the job step to retry x times every y minutes?Thu, 08 Nov 2012 02:40:26 GMTStewart "Arturius" Campbellhttp://www.sqlservercentral.com/Forums/Topic1382227-391-1.aspxGreetings All,I have an SSIS package that generates a text file, then uploads the text file to a SFTP site for processing using WinSCP. The packages needs to be able to download the file from the SFTP site after processing has been completed. The file processing can take 10 minutes or up to 10 hours. I configured a for loop container with an execute process task to download the file. I would like to set up for loop to continue looping until the execute process task in the container is successful.I have tried various way to accomplish this and none of them produced the results I need.My process needs to do the same thing as described in the question in this post.http://go4answers.webhost4life.com/Example/loop-execute-process-until-successful-77548.aspxI tried all the solutions on that page and none of them worked.Any assistance with this would be greatly appreciated.Thanks for looking.Edit: I am also open to other ways within SSIS to accomplish this -e.g. script task. I am not able to install any custom components in SSIS. I know there are several out there that may do what I need.Wed, 07 Nov 2012 18:14:47 GMTKasumisCat