HI all, I am getting follwoing information during ssis package execution.Information: The buffer manager has allocated 3997600 bytes, even though the memory pressure has been detected and repeated attempts to swap buffers have failed.can any one give me some idea about this.

Hi Ron,It is simply saying that you are running out of resources or you have misconfigured smth in your sql server or SSIS itself.There is a document about it. If you are running SQL Server 2005 follow: http://www.badlydressedboy.com/docs/TShootPerfProbs2005.docIF you are running 2008 follow: http://download.microsoft.com/download/D/B/D/DBDE7972-1EB9-470A-BA18-58849DB3EB3B/TShootPerfProbs2008.docxBest RegardsOnurBI and ERP Consultant @ Nexum Bogazici Personal Blog: http://www.ssisnedir.com/blog

HI all, I am getting follwoing information during ssis package execution. Information: The buffer manager has allocated 3997600 bytes, even though the memory pressure has been detected and repeated attempts to swap buffers have failed. can any one give me some idea about this. What are the different component/ transformation in DFT in your package? Let us TRY this | Dont forget to mark the post(s) that answered your question http://quest4gen.blogspot.com/

HI all, I am getting follwoing information during ssis package execution.Information: The buffer manager has allocated 3997600 bytes, even though the memory pressure has been detected and repeated attempts to swap buffers have failed.can any one give me some idea about this. THis is causing due to the fact that you are running out of memory. I guess you are using some lookup transformations in your dataflow task.Write a select query which will select only requried columns from the table instead of selecting a table from a drop down. This will be reduce some memory usage .Raju

i am quering only on required columns but i have aggrigate in this DFT, and have more than 50 mil records to store in aggrigate. when i remove some aggrigates from dft it works fine but i can not do this all the time to figure it out how many aggrigate functions will i need.

i am quering only on required columns but i have aggrigate in this DFT, and have more than 50 mil records to store in aggrigate. when i remove some aggrigates from dft it works fine but i can not do this all the time to figure it out how many aggrigate functions will i need. There is a way to come out this problem. follow these steps.. Step1: Save your data to a table in DFT1. Step2: Drag DFT2 , and use OLEDB Sourec . Step3: Write a SQL command (Query) in OLEDB source to aggregate the data. OR Write a Stored procedure for doing this aggregation and call it in OLEDB Source. Let us TRY this | Don’t forget to mark the post(s) that answered your question http://quest4gen.blogspot.com/

I think ETL has the answer. You can use SQL Command option to do the aggregates inside the OLEDB Source itslef. Nitesh Rai- Please mark the post as answered if it answers your question

I often see work-arounds suggested by Nitesh. Problem is, suppose table with 200,000,000 rows is on Server A, which is tuned for data read. Suppose the SSIS Server is on a dedicated ETL Server (Server B) which is tuned for transforming data. The work around above simply delegates the work to Server A, which totally defeats the purpose of having a dedicated ETL server. There needs to be some solution where by a box with 59GB of RAM (our ETL server) can manipulate a 10GB data set without crashing.