sql server dts: No Logging for DTS Batch -- sql server dts

No Logging for DTS Batch

Ben
8/30/2004 8:06:11 AM

sql server dts:

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,

Re: No Logging for DTS Batch

Allan Mitchell
8/30/2004 5:09:58 PM

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

[quoted text, click to view]