The Pipeline Limiter in SQL Server Integration Services (Video)
Not many people understand that the Integration Services pipeline can be intentionally throttled back under the covers to stop you from running out of memory. In this video we show you how to detect this is happening and explain more about the limiter itself.