Importing large ascii text file, 14MB.

Posted on 2005-04-19
Last Modified: 2010-03-19
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
Question by:johndamato
    LVL 28

    Expert Comment

    Is that the exact error that you are getting?
    LVL 28

    Expert Comment

    Can you please post the exact error message that you get.

    Author Comment

    "Not enough storage is available to complete this operation."
    LVL 28

    Accepted Solution

    Check if this addresses your issue:

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now