Server: Msg 50000, Level 16, State 1, Procedure dt_displayoaerror

[gcole]

I am intermittantly getting the following error when I run an sp that executes a DTS package. Anyone have any suggestions?
Thanks,
Gail


Server: Msg 50000, Level 16, State 1, Procedure dt_displayoaerror, Line 16
Microsoft Data Transformation Services (DTS) Package: Not enough storage is available to process this command.
*** LoadFromSQLServer failed

 

[nigelrivett]

Are you low on disk space?

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[ClaireHCM]

Check out this article

http://support.microsoft.com/default.aspx?scid=kb;EN-US;221513

When attempting to import a text file larger than the available memory on a Windows 95 or 98 client, one of the following errors may occur:

Not enough memory to complete this operation. Quit one or more application to increase available memory, and try again.
-or-

Error Source: Microsoft Data Transformation Services Flat File Rowset Provider Error Description: Error creating file mapping view: Not enough storage is available to process this command.