To followup from The buffer manager failed a memory allocation call for 20485670 bytes, but was unable to swap out any buffers to relieve memory pressure blog post, here are few findings that I would like to share. When you see that SQL Server instance throws the error as per above blog post, the amount of memory that can trigger this issue varies for different computers. If the package is really handling huge number of rows such as millions of rows during import/export operations, then allocate...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/bi/archive/2010/02/05/ssis-package-transformation-performance-issues-follow-up.aspx