BUG: DTS - Error Creating File Mapping View

• Microsoft SQL Server version 7.0

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.

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 version 7.0.

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

Keywords : kbbug7.00
Version : winnt:7.0
Platform : winnt
Issue type : kbbug