When attempting to save an SSIS package in Visual Studion I receive the following error message detailed below. If I attempt to "Save As" to another location, I then receive an insufficient storage error. The development machine has over 1.5 GB of available physical memory and several GB of disk space availabe to save my 16 MB package. I have checked the event log and have found no related messages in the Application or Server logs. Any suggestions on how to determine the cause or resolution of this error message would be greatly appreciated. Failure saving package. (Microsoft Visual Studio) Insufficient memory to continue the execution of the program. (Microsoft.SqlServer.ManagedDTS) Advanced Error Message Details Failure saving package. (Microsoft Visual Studio) ------------------------------ Program Location: at Microsoft.DataTransformationServices.Design.Serialization.DtrDesignerSerializer.SerializePackage(IDesignerSerializationManager manager, Package package, TextWriter textWriter) at Microsoft.DataTransformationServices.Design.Serialization.DtrDesignerSerializer.SerializeComponent(IDesignerSerializationManager manager, IComponent component, Object serializationStream) at Microsoft.DataWarehouse.Serialization.DesignerComponentSerializer.Serialize(IDesignerSerializationManager manager, Object value) at Microsoft.DataWarehouse.VsIntegration.Designer.Serialization.DataWarehouseDesignerLoader.Serialize() at Microsoft.DataWarehouse.VsIntegration.Designer.Serialization.BaseDesignerLoader.Flush(Boolean forceful) at Microsoft.DataWarehouse.VsIntegration.Designer.Serialization.BaseDesignerLoader.Flush() at Microsoft.DataWarehouse.VsIntegration.Designer.Serialization.DataWarehouseContainerManager.OnBeforeSave(UInt32 docCookie) =================================== Insufficient memory to continue the execution of the program. (Microsoft.SqlServer.ManagedDTS) ------------------------------ Program Location: at Microsoft.SqlServer.Dts.Runtime.Package.SaveToXML(String& packageXml, IDTSEvents events) at Microsoft.DataTransformationServices.Design.Serialization.DtrDesignerSerializer.SerializePackage(IDesignerSerializationManager manager, Package package, TextWriter textWriter)

I am running "Microsoft SQL Server Integration Services DesignerVersion 9.00.2047.00 (SP1)" I have package of size 12 MB. While working, it regularly gives above error while saving. I have 2 GB RAM, 150GB disk Nearly 2gb Virtual memory. What should I do 1) Split the package to 2 or more packages or any other resolution Thanks in advance Dharmbir

I would consider breaking it down into more packages. You could use one "master" package to execute the other packages. That may make it easier to maintain, as well.

This error is frustrating; hopefully Microsoft will identify the solution... In the meantime, I have found that if you select "SAVE ALL" instead of "SAVE", this error does not occur. Unfortunately it took 4 months of aggrevation before I figured this out... Good luck. B. Wayne Finley SQL MCITP Administration, development DBA