DTS package Error "Not enough storage is available to process"

[sonname]

Hi
I have a DTS package that I am trying to run, it used to work just fine, now I get the error 0x80070008, not enough storage is available to process this command. I have no clue why this is. I receive this error in my procedure right after I try to load the package

Here is the code where it fails


Exec @hr = sp_OAMethod @pkg, 'LoadFromSQLServer',
NULL, @Server, @PackageName = @PkgName, @Flags = 256


Any help is really appreciated!!

 

[anilkutty]

Strangely enough the same error popped into our system,
but we were not able to connect to our Shared drives.
The problem was because there was no memory free on our
servers, caused by running of norton antivirus.

A simple reboot did the trick, hope it works for you too,
best of luck.