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?