Thursday, July 26, 2012 1:38 PM
we've upgraded ssis 2008 R2 packages to 2012. All the packages converted to 2012 successfully. Im trying to convert the solution from package deployment model to project deployment model. few packages giving below errors while converting
Exception of type 'System.OutOfMemoryException' was thrown. (Microsoft.SqlServer.ManagedDTS).
Pls let me know how to fix this issue.
Thanks in advance
Friday, July 27, 2012 4:24 AMModeratordid you tried steps like this article? http://www.bidn.com/blogs/DustinRyan/bidn-blog/2610/upgrade-2005-2008-ssis-packages-to-2012-like-a-boss and in which step you get problem?
Monday, July 30, 2012 6:45 AM
yes, followed the steps as mentioned in the blog. I'm getting this error when i select packages and click next in project deployment model. This error is coming randomly and not specific to particular package.
Monday, July 30, 2012 7:19 AM
Thursday, August 02, 2012 10:03 AMModerator
This problem occurs because heap memory is fragmented in the SQL Server Business Intelligence Development Studio process. 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.