SQL Server Performance Forum – Threads Archive
Disabling DTS For Certain usersHow can i disable certain users from running DTS /import and export without affecting their noramal read operations in sql query analyser
Checkhttp://vyaskn.tripod.com/sql_server_dts_best_practices.htm DTS best practices and KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;282463 fyi, I think it is not possible to restrict on certain areas of DTS. I believe SSIS is good at this feature. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.