Is there anyway that I can hide or restrict DTSs from
users?

Thanks,
tt

Hi

What do you mean by this?

"Users" should not have client tools installed.

John

"tuand2001 (AT) yahoo (DOT) com" <anonymous (AT) discussions (DOT) microsoft.com> wrote

John,
I think you defence is flawed. Just because someone shouldn't haven't
something doesn't mean they do not.

TT,
You cannot stop people from building and executing packages. You can
however stop them from accessing your packages by securing your storage
location. I guess you mean packages in SQL Server, in which case start
by removing the guest user from the msdb database.

Packages are stored in the sysdtspackages table, and the MS tools use
stored procedures, such as sp_enum_dtspackages, so ensure no permissions
have been granted to either of these.

Darren

In message <OsLFAMlTEHA.3512 (AT) TK2MSFTNGP12 (DOT) phx.gbl>, John Bell
<jbellnewsposts (AT) hotmail (DOT) com> writes
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Hi Darren

It wasn't meant as a solution!

It could be that this is a third party application and he does not have
authority to change the access on anything other than his own database!

John

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote