Hi,

The following error message is received during the transformation of
data from a text file (262 columns) into SQL database.

"Not enough storage is available to complete this operation"

Is there any specific reasons?

Thanks


*** Sent via Developersdex http://www.developersdex.com ***

Check to see if you have enough disk space.

Rick

"John Jayaseelan" <johnj (AT) savcredit (DOT) co.uk> wrote

John,

I have received the same message from a DataPumpTask that has been running
correctly on several different servers for a couple of years....until I
tried running it on Windows 2003 Servers that have recently been upgraded to
SP1.

I have confirmed this problem by running the same task successfully on a
much older Windows 2000 server that has considerably less disk space and
memory. I am trying to discover what part of the Transform is being rejected
by Win2003 SP1. The same task ran smoothly on Win2003 prior to the SP1.

My guess is that the "Not enough storage..." message is an incorrect error
message and we will soon be seeing more posts of this nature..

Question for the group:
Does anyone know if there is another recent service pack for SQL Server that
needs to be applied to accommodate Win2003 SP1?

"John Jayaseelan" <johnj (AT) savcredit (DOT) co.uk> wrote

Hi,

Plenty of disk space available. Is there any limitation in no of
columns?

Thanks


*** Sent via Developersdex http://www.developersdex.com ***