Error message when you save a SQL Server 2005 Integration Services package in SQL Server Business Intelligence Development Studio: "Exception of type 'System.OutOfMemoryException' was thrown"

View products that this article applies to.

System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

Expand all | Collapse all

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

Back to the top

CAUSE

This problem occurs because heap memory is fragmented in the SQL Server Business Intelligence Development Studio process.

Back to the top

WORKAROUND

To work around this problem, break up the SSIS package into smaller packages. If you want to provide contiguous workflow in the package design, you can run the child packages from the context of the parent package by using the Execute Package task. Or, run the child packages as separate steps from a SQL Server Agent job.

Back to the top