not enough storage is available to complete this operation err msg -- sql server (microsoft)

Dica
6/22/2006 6:10:07 PM

i'm receiving this error message in my dts package:

Error Source: Microsoft OLE DB Provider for SQL Server
Error Description: Note enough storage is available to complete this
operation.
Note enough storage is available to complete this operation.
Note enough storage is available to complete this operation.

i've got a txt file with 370 columns i'm trying to import into a table with
the same number of columns. according to kb 889170 article, this is a known
issue and can be resolved by installing sp4, which i've done, but nothing is
changed/fixed.

anybody know how to resolve this?

i'm running sql enterprise edition, sp4 on a windows 2000 advanced server.

tks

Dica
6/22/2006 6:39:21 PM

[quoted text, click to view]

never mind. found the problem. i was importing the txt file to a table with
exactly the same columns. i created that table based on the txt file import.
when you use a txt file to create a new table, enterprise manager sets all
the columns to varChar(8000). by reducing the 8000 to something more
manageable, i've fixed the problem.

sql server (microsoft) : not enough storage is available to complete this operation err msg