Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
project deployment model error

Unanswered project deployment model error

  • Thursday, July 26, 2012 1:38 PM
     
     
    Sign In to Vote
    0

    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

     

All Replies

  • Friday, July 27, 2012 4:24 AM
    Moderator
     
     
    Sign In to Vote
    0
    did 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?

    http://www.rad.pasfu.com

     
  • Monday, July 30, 2012 6:45 AM
     
     
    Sign In to Vote
    0

    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
     
     
    Sign In to Vote
    0
    The error indicates that you have a memory issue. Maybe try a restart of the system?

    MCTS, MCITP - Please mark posts as answered where appropriate.

     
  • Thursday, August 02, 2012 10:03 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi msbimsbi,

    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.

    Thanks,
    Eileen