Re: No Logging for DTS Batch

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 08/30/04 

Date: Mon, 30 Aug 2004 17:09:58 +0100

You can't.

SQL Server will _ALWAYS_ log something and logging as far as transactions
are concerned are DB wide not table.

The closest you will come to is to to set your DB to SIMPLE mode during the
batch load, remove any indexes and triggers from the destination table as
well. You could also do with using batches (last tab of the DataPump setup)
or it is one of your options on the BULK INSERT task. This will let the log
breathe. 

-- 
-- 
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know
"Ben" <anonymous@discussions.microsoft.com> wrote in message
news:2b4701c48ea2$e2ff8820$a501280a@phx.gbl...
>
> I have a database with multiple tables.  I perform 2 mass
> imports a day on the tables from a txt file.  None of the
> columns are labeled or are in order so I cannot use any
> command line utitlies for the import.  I have the import
> working in DTS, but I DO NOT WANT IT TO LOG THE
> TRANSACTIONS.  I do not want to do a truncate log either
> because I don't want to lose any information from
> transactions on the other tables.  This is how I import
> the data.
>
> Drop Table
> Create table
> DTS- import task
> Alter table to add keys and clean data.
> Set permissions
>
> Where and how do I put in a commant to not log anything
> in this transaction, yet maintain logging on any other
> table in the database.
>
> Thanks,
> Ben