I have started having a problem with my SQL Server 2005 SSIS system and it has become a nightly event. What is happening is that sometime in the evening before 7:30 the server gets into a state in which any SSIS job that attempts to run, fails. The error message that SSIS reports is:
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "Could not bulk load because SSIS file mapping object 'Global\DTSQLIMPORT ' could not be opened. Operating system error code 8(Not enough storage is available to process this command.). Make sure you are accessing a local server via Windows security.".
I can bounce the SQL Server service and then packages run normally.
I will be greatful to anyone who can help with this error.
Best Regards,
Mark Redman.
Just searching I see this KB about server configuration.
"Err Msg: Not Enough Server Storage Is Available to Process This Command"
http://support.microsoft.com/kb/225782/en-us
Hope that helps
|||This Error has been solved. It turned out that all of the jobs were using the SQL Server destination with a named instance. Even though the destination was the local server, it appears that unless you use the <Local> designation, the server believes that you are going to a remote machine. Once I changed all of the destinations to an OLEDB connection, the errors disappeared.
No comments:
Post a Comment