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:
-or-
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
