SQL Server Performance Forum – Threads Archive
Regarding DTS Packagehi,
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..
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
This posting is provided AS IS with no rights for the sake of knowledge sharing.