Hello.

I have a DTS package that imports a text file into a SQL 2000 table.
When I tested the package I used a file that's 64 MB.
I then used a live file that's 1.2 GB and got the following error message.

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.

The server currently has 83 GB of free space.

Is there something that I can do to overcome this issue?

TIA.

Rita

Hello RitaG,


There are some suggestions listed here

http://www.google.com/search?client=...utf-8&oe=utf-8

Do any of them help you?

Allan

Its Known bug,

Check this link ->

http://support.microsoft.com/default...en-us%3B221513

CAUSE =>

When importing a text file, the DTS Import Wizard calls the command
MapViewOfFile in order to display the structure of the file being imported.
If the user is working on a Windows 95 or Windows 98 computer, the
MapViewOfFile call will attempt to reserve a contiguous area of memory large
enough to map the entire file, even though only a small part of the file will
be displayed.

Windows 95 and 98 use a shared memory space for this mapping and thus will
be limited to less than 1 GB. How much less depends on what applications are
loaded on the system at the time of the MapViewOfFile call.

WORKAROUND =>
To work around this problem, use a client computer running Windows NT when
importing large text files by means of the DTS Import Wizard.

Thanks,
Sree

"RitaG" wrote:

Thanks Sree for your response.
My production server crashed a couple of weeks ago and so I'm only able to
get to this problem of mine today.

I found out that the input file didn't have a CRLF at the end of each line.
I had to write a program that appended CRLF after each row and then the DTS
worked fine.

Rita

"Sreejith G" wrote: