Windows 2000 Server SP4, Dual 2.4 GHz P4 Xeon machine, 3776 MB RAM
SQL Server 2000, all patches and service packs applied

I am trying to import 6 text files (comma separated data) with roughly 9000
rows and 900 columns (file extension is .txt not .csv). Each file is about 10
MB in size.

I have researched my issue thoroughly in Google (web and groups) and
couldn't find the answer to my question.

When I try to import each of these files using DTS (text file as the
source), I get the 'Not enough storage is available to complete this
operation' error. There is plenty of hard drive space and I got rid of lots
of tables to free up the database. The database has about 250 MB of free
storage. All files are set to grow unlimited.

Does anyone know how to solve this problem? What are the settings I can
tweak? Is there any hotfix (I don't think so) available from Microsoft that
addresses this issue?

I am positive that this, even though it says that, is not a space issue.
There must be some settings which may need to modify.

Please help if you can.

Thanks.

AppDev,

Follow the link and read threads:
http://groups.google.com/group/micro...rch+this+group

In my case it boiled down to getting rid of lookups in transformation tasks.

Ilya

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