2005 & 2008 SSIS Packages

I know in 2000 I cannot setup a user to only be able to execute and modify only certain DTS packages.  It is either all of them or none of them.  With SQL Server 2005 or 2008 in SSIS is it possible to do this?
LVL 12
Nathan RileyFounderAsked:
Who is Participating?
Eugene ZCommented:

Integration Services includes the three fixed database-level roles db_dtsadmin, db_dtsltduser, and db_dtsoperator for controlling access to packages
Security Considerations for Integration Services
execution you may try to control via sqlagent jobs for SSIS pack
access you may try to control by placing SSIS pack in folders witj NTFS permissions for specific users
I dont know about user based permissions. But you can set passwords on the packages and share it with only the users that should get access on them
Nathan RileyFounderAuthor Commented:
Well what do you mean users that get access on them?  So I can say that user test can only access these SSIS packages but not others?
I don't think there any option grant the access to perticular SSIS package(s) to one or more logins but you can create a procedure with the option EXECUTE AS  using xp_cmdshell and dtexec to execute ssis package and GRANT the execute permissions to the user.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.