Microsoft KB Archive/221513

= BUG: DTS - Error Creating File Mapping View =

Article ID: 221513

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



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.

Additional query words: win95 win98 win9x win 9x data transformation services

Keywords: kbbug kbpending KB221513

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.