January 20, 2012 at 10:34 am
Perhaps I'm not looking under the correct terms but what I'm trying to accomplish is to execute my SSIS package in a loop so that after the last task is accomplished with success it starts over.
Something simple?
Donalith
January 20, 2012 at 12:19 pm
Hi,
so loop forever? infinite loop ?!
You could look at http://www.sqlis.com/post/For-Loop-Container-Samples.aspx
Why don't you schedule a SQL agent job to run every 1 hour or so ! instead of killing the server's memory?
January 20, 2012 at 1:37 pm
I'm using the loop container now. The process takes a variable time between 10 and 20 minutes per iteration and I'm looking to minimize the time between iterations with a check at the end to see if it needs to run again.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply