When trying to import a larger text (400 MB) file into my database using DTS
Import I am getting the following error:
Error at Source for Row number 450063. Errors encountered so far in this
task: 1. Not enough storage is available to complete this operation.

I successfully imported two large text files (1 GB each) the other day.

I am running SQL Server 2000 SP4 on Windows 2003 SP1 Server Enterprise Edt.;
Dual Xeon 2.80 GHz; 4 GB of RAM; 80 GB of free space on my HD; 6 GB of total
paging file size.

Any help would be greatly appreciated.

Hi,

Have you set your database to auto grow?

Ray

"Boro" wrote:

Yep.

"rb" wrote: