Runing DTS package without log

[wg26]

Hi Everybody:

I have created a DTS package to transfer data between Access and SQL...But I run this package, it generates a large log file...I don't really need to log this transaction...Can anyone please tell me what I need to do to stop SQL writting the transaction to the log file?...Thanks

 

[Corran007]

Which log are you speaking of.

In the dts package itself under properties, there is an option on to turn off/on logging.

If your speaking of any changes made to the transaction log, dont know of any way to avoid that.