Symptoms
Consider the following scenario. In Microsoft SQL Server 2005 Integration Services (SSIS), you create an SSIS package. The SSIS package contains some Script tasks or Script components. When the file size of the SSIS package increases to more than 7 megabytes (MB), you receive the following error message when you try to save the SSIS package in SQL Server Business Intelligence Development Studio:

TITLE: Microsoft Visual Studio
Failure saving package.
ADDITIONAL INFORMATION:
Exception of type ‘System.OutOfMemoryException’ was thrown. (Microsoft.SqlServer.ManagedDTS)
BUTTONS:
OK
Resolution
This problem occurs because heap memory is fragmented in the SQL Server Business Intelligence Development Studio process.