DTS in SQL Server 2008
I have migrated DTS into the new SQL Server environment and under legacy is there way to have ability to open the DTS but not able to execute it?
May 3rd, 2011 3:14pm
Do you mean to limit the functionality of your users/developers in the DTS arena? Best way might be to limit their access in the databases themselves. DTS does not have the Security Groups in msdb like SSIS does.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
May 3rd, 2011 4:32pm