Foreach iteration delay

• CraigIW

  SSCrazy

  Points: 2301

  More actions

  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.

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  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/

  

• Phil Parkin

  SSC Guru

  Points: 246988

  More actions

  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

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel