Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 SSIS packages and memory

Author  Topic 

andrewhopkinson
Yak Posting Veteran

63 Posts

Posted - 2010-03-19 : 10:40:29
Hi, I am have created a large SSIS package to download about 14 gigs worth of data daily to a local reporting server. I have a 64-bit machine with 32 gigs of RAM on it. I notice that the SSIS package takes about 6 gigs of RAM from the SQL Server, however if I run the package again, it takes and ADDITIONAL 6 gigs and so on, it never seems to release the memory. Is there something I'm doing wrong? Is there any way to release the memory after the package is run without restarting the SQL Server? thanks.
   

- Advertisement -