Error during SSIS package deploy - Failed to create AppDomain "SSISDB.dbo[runtime]

1
votes

I'm trying to deploy package on SQL Server and during execution I'm getting following error. On server already exists packages so it shouldn;t be problem with SQL Server Configuration itself. Any ideas?

Failed to create AppDomain "SSISDB.dbo[runtime].18". Could not load file or assembly 'System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. Not enough storage is available to process this command. (Exception from HRESULT: 0x80070008) (.Net SqlClient Data Provider)

1
sql-serverdeploymentssissql-server-2012sql-server-2014
Did you find a solution to this? I have the same error, plenty drive space, DB space and memory space available. – Sean
Never mind SQL Server restart fixed the problem. – Sean

1 Answers

0
votes

Note from your post "Not enough storage is available to process this command" you don't have enough storage available. Another thing you have to set overwrite property for your ssis project.