Post reply

Foreach iteration delay

  • June 20, 2012 at 4:37 am

    #271510

    Hi,

    I have an SSIS package that produces around 20 files. Each of these has to be moved to somewhere on the network after it has been written. Rather than add a move step after each file is produced, I used a Foreach loop once they are all done, with a Filesystem task in the loop to move them. This works well, except the system which monitors the final target folder does not handle lots of files in quick succession very well. I would therefore like to introduce a delay within the For loop.

    How can this be achieved? The only way I can think that may work would be to add a Script task which contains only a Thread.Sleep. Would this work? Is there any other way?

    Thanks.

  • June 20, 2012 at 7:12 am

    #1503385

    The approach with a script will work good.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • June 20, 2012 at 7:20 am

    #1503396

    If you'd rather avoid code, you might like to have a look at the Pause Task[/url] on CodePlex.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply