Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSIS 2008 For Loop Container to loop until execute process task in container is Successful


SSIS 2008 For Loop Container to loop until execute process task in container is Successful

Author
Message
KasumisCat
KasumisCat
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 254
Greetings 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.aspx

I 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.
Stewart "Arturius" Campbell
Stewart "Arturius" Campbell
SSCertifiable
SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)

Group: General Forum Members
Points: 5769 Visits: 7130
Is 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?

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
KasumisCat
KasumisCat
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 254
This 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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search