I have a stored procedure which uses sp_OAMethod to load a DTS structured
storage file useing the method DTS.Package.LoadFromStorageFile. Today the
call to that method is throwing an error, "Not enough storage is available to
complete this operation." This procedure has worked for years without a
problem, but today it is failing sometimes.

The system admin of the SQL server assures me there is plenty of physical
disk space, the master and msdb database have space available, and there is
plenty of memory available on the server.

I need to understand what the LoadFromStorageFile method does that is
throwing an error that there is not enough storage. My current theory is
that there may be a sort of memory leak from failed instances of DTS packages
that has accumulated to the point it is a problem all of the sudden today.
In which case, a reboot of the server or restart of the sql instance might
get the system running again. Any help explaining what could be a cause of
this is much appreciated.

-- Thanks