BUG: DTS - Error Creating File Mapping View (221513)
The information in this article applies to:
This article was previously published under Q221513
BUG #: 54509 (SQLBUG_70)
SYMPTOMS
When attempting to import a text file larger than the available memory on a Windows 95 or 98 client, one of the following errors may occur:
Not enough memory to complete this operation. Quit one or more application to increase available memory, and try again.
-or-
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.
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.
STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.
| Modification Type: | Major | Last Reviewed: | 10/16/2002 |
|---|
| Keywords: | kbBug KB221513 |
|---|
|