How to set up time interval for a send email task within an for each loop?


  • Hi All:

        I have get a problem about the sending email task within a for each loop. As it goes really fast and make our exchange server down.

        Can i please ask is there any way to set a time interval for acting each "loop"? for example, set 30 seconds as the time lag after finishing exciting a "Foreach ADO Enumerator".  Can SSIS do this? or do we have other method to achieve this?


    Thanks a lot


    Friday, March 26, 2010 3:09 AM