I am new to SQL and DTS. I am trying to import a 3 GB text file and the log file had grow so big that it run out of disk space. My question is; if I don't care about the log file, can I turn it off? How?

Thanks in advance.

No

SQL Server requires the transaction log file in order to make sure amongst
other things that things are consistent in the DB.

Things that will help you

1. DB in SIMPLE recovery mode
2. No triggers on table you are inserting into
3. On the last tab of the datapump task you can set DTS to import using
batches

ALSO look at the BULK INSERT TSQL command and the BATCHSIZE parameter

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"mitcas" <anonymous (AT) discussions (DOT) microsoft.com> wrote

I don't care about the log file, can I turn it off? How?