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...
Thanks.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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment