DTS -- NO Logging

[Guest_imported]

How do you turn LOGGING OFF for a DTS package????

DB2 is a simple "LOAD DATA REPLACE NO LOG"... (can SQL Server make it any more difficult to find this option to turn on/off??!!!)

frustrated!!!!!!!!!!!!!!!!
thanks-

 

[Cagliostro]

on usig databases you don't log on/off but connect/disconnect. It means try to disconnect somewhere. John Fill

ivfmd@mail.md

 

[foxdev]

You cannot turn off transaction logging in DTS. About the only way to load a large amount of data and use a minimal amount of log space is to use BCP with the "bulk log" model (this applies to SQLS 2000). Robert Bradley

http://www.agrainofhope.org

http://www.lowcostprints.com

http://www.foxdev.com