Hi,

I have created some DTS Packages in the SQL Server.
The SQL Server is shared between two projects.

I need to give access to DTS packages of Project A for only Project A users and similarly for Project B Users.
Please let us know how can i give partial access rights.

Regards,
Sanka

You can use

1. Owner/Executir passwords which are different for each package depending
on team
2. Use Structured Storage files and lock down the directories.


--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Sanka" <loonysan (AT) mailcity (DOT) com> wrote