Hello All,

I have a process which loads and executes a lot of DTS packages thru a
stored procedure using OLE Automation. This process had been running fine,
all the way thru. Now at different pkgs (different spots in the process), I
receive the following error when calling the load (SP_OAMETHOD @iPkg,
'LoadFromSQLServer',
NULL,
@Servername = @@SERVERNAME,
@Flags = 256,
@PackageName = @vchPackageName)
and execute (SP_OAMETHOD @iPkg, 'Execute') methods:

Not enough storage space to process this command

Can anyone tell me how to fix this? The only information I can find says to
stop and start the SQL Services and when I do this the process runs again
once or twice without error and then I get the same error again. Is there
any other way to fix this?

Thanks,
Denise

Denise

Could it be that your resources are depleting? if restarting the service
fixes things and then it fails again in a few days then it sounds like you
may have some resource issues. A good place to start would be memory. Are
you leaking?


--


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com


"DeniseMe" <DeniseMe (AT) discussions (DOT) microsoft.com> wrote