Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003

    Unanswered: Saving Disk Usage

    I import about six 30,000-line text files to my database daily using a few DTS's - is there a way to "turn off" the transaction log for these imports to conserve disk space? I do not need to log these inserts...


  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    If Recovery Mode is set to Simple you can modify the transformation task by specifying "Insert batch size" value in Properties of the task (Options tab). In your case you can set it to something like a 1000 or so. This way every 1000 rows inserted would be viewed as a transaction that would be immediately committed, the database will be CHECKPOINTed, and the log will be flushed, - eliminating the need for growth.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts