• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 246
  • Last Modified:

Importing large ascii text file, 14MB.

I want to import a large ascii (fixed field) text file: 14MB.  I get 'not enough space' error using the import wizard.  The drive my SQL Server is on has 9GB.  I increased size of mdf & ldf to 100mb and config size to grow by 1MB.  Same error.  The text file has 228 fixed length fields, the total width of the row is just under 1600 bytes.  It has (I'm guesstimating) about 8000+ rows.

John D'Amato
0
johndamato
Asked:
johndamato
  • 3
1 Solution
 
rafranciscoCommented:
Is that the exact error that you are getting?
0
 
rafranciscoCommented:
Can you please post the exact error message that you get.
0
 
johndamatoAuthor Commented:
"Not enough storage is available to complete this operation."
0
 
rafranciscoCommented:
Check if this addresses your issue:

http://support.microsoft.com/?kbid=889170
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now