SQL Server Performance

Regarding DTS Package

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by shdeepak2000, Nov 12, 2006.

  1. shdeepak2000 New Member

    hi,
    while working on the DTS package i found that the transactions are set to ON.
    So if i disable "Use Transactions" Checkbox for the DTS Package how would it impact the performance of the DTS Package. please suggest which option is preferable and why?.

    Deepak..
  2. satya Moderator

    It will have impact on transaction log for a bulk load operation, it is suggest to keep the settings by default.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page