June 20, 2012 at 4:37 am
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
June 20, 2012 at 7:20 am
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy